Report to only show totals?

[dan231]

I have a vehicle daily log table that shows Van# and Daily Mileage.
I am working on a report that shows the total mileage per van per date range like so:

Van1 Total Mileage
Van2 Total Mileage

I'm not sure how to proceed with this. All my attempts so far are not good. All I can get is all records on me page sorted by Van#. I have not tried the date range yet. I was trying to get the totals done first.

Can anyone point me in the right direction?

Dan

 

[Kryst51]

Use a query which groups by van # and sums the mileage, and filters by the dates you want. Build your report based on that query.

 

[dan231]

I'm not sure what you mean by group by van#.

I can add a pop up that asks for Van#, but that will only return 1 van.

ALSO, I only have 1 date field, which is the use date of the van. For this purpose how do I filter by a date range?

 

[Kryst51]

I have attached a sample db and JPEG, of what I mean.

 

[dan231]

I don't have a Total option in my query...I am on Access 2003

 

[Kryst51]

As am I, there should be in your menu an option to show the total row, in my pic example it looks like an E, it is a greek symbol.

 

[dan231]

AWESOME!!!!

Thank you so much.
I have spent 1.5 days on this already LOL

Thank you again!

 

[Kryst51]

You are very Welcome.... And Actually trying to figure stuff out yourself before asking is always a good idea, you will learn things better that way, I am glad we could help!