Report Total

[walters]

I have a query with total quanity shipped by date. I want a report that will
show total shipped by month showing all months of year. I have one showing
total for each month but don't know how to get each month total on one
report.
Thanks!

 

[John W. Vinson]

I have a query with total quanity shipped by date. I want a report that will
show total shipped by month showing all months of year. I have one showing
total for each month but don't know how to get each month total on one
report.
Thanks!

Add a calculated field to your query:

ShipMonth: Month([shipdate])

Use this with Group By in a Totals query, or in the Sorting and Grouping
feature of your report.