combine values from specific records then list those records showing totals for each

[dreed64997]

I have created a database for keeping my trip and mileage records for my transportation business so I can print out my fuel tax report by state. The table I have is called tblhighways. The fields are HighwayID, StateId (Which gets its information from tblstate), odometerstart, and odometerend. On the form I have a field to calculate the miles for the state, but I want a query that will calculate the mileages for each state then combine that value for each state without having to do it by having to enter each state separately as a search criteria, then show a listing of the total for each state without showing the state more than once. The query will show the results for a 3 month period.

Any help would be appreciated.
.

[ranman256]

a form, (frmRpts) will have 2 dates, txtStartDate, txtEndDate
qsMiles, will pull data from these dates
select state, [odoEnd]-[odoStart] as Miles where [date] between forms!frmRpts!txtStartDate and forms!frmRpts!txtEndDate

qsMilesTotal, will use the query above
select State, Sum(Miles) as TotalMiles from qsMiles