join table1 to table2 on routid

Thanks... that worked.  Now all of my summary totals are out of whack.  I know have four group levels with this new group.  At each level I need it to subtotal the miles, hrs, ect.  Is there a way to total just the group totals and not the details?  I am getting a subtotal for group three that is substantially higher than if I were to add up the summary totals of group 4.

In order to accomplish my original goal I went ahead and took the above suggestion of creating a new group based on route ID to I could get the total of the gallons recorded by route id on table two.  So I moved the route id, miles driven, hours ect up into the header for this new group 4 so it would match up with the gallons collected.  Now for groups 1, 2, and 3 the totals for the miles and hours are way too high.  I think it might be calculating the detail along with the totals calculating in the header in group 4 so it is compounding the value.  Does this make sense?  

So last question on this and I will close.  First I want to thank you for all of your help. 

So my last issue is that I needed to add a third table that is linked by route id.  Like table 2 above it has all of the stops listed but table three has two values for each stop... Arrival time and departure time.  The total service time is equal to departure time less arrival time.  What I would like to do is sum all of the stops service time on this report so I can compare total route time vs service time.  Since this is a formula I am pretty sure that a summary can not work.  I have added a running total for this formula and I am not getting the correct answer.  Any suggestions?

Table 1
Route ID   Route Date   Driver Name   Miles Driven   Hours on Route
11111       9/30/2013    xxxxxx            1000              50
22222       9/1/2013      bbbbb             200                 6
33333       9/15/2013    cccccc              100                 8
44444       9/10/2013    ddddd              50                  9
 
Table 2
Route ID  Location ID  Gallons Collected
11111             1a                      5
11111             1b                      6
11111             1c                     10
22222             1d                     25
22222             1e                     30
44444             1f                      20
44444             1g                     30

Table 3

Route ID  Location ID  Arrival Time  Departure Time
11111             1a                10:00         10:05
11111             1b                10:30         10:37
11111             1c                 10:40         10:45
33333             2a                9:15            9:30
22222             1d                11:50          11:58
22222             1e                12:05          12:10
44444             1f                 8:30            8:35
44444             1g                8:50            8:55

I want to create a report that shows the following:

Route ID   Route Date   Driver Name   Miles   Hours   GC  Service Time
11111       9/30/2013    xxxxxx            1000    50        21         .28
22222       9/1/2013      bbbbb             200      6         55          .30
33333       9/15/2013    cccccc              100       8          0          .25
44444       9/10/2013    ddddd              50      9          50          .17