Report Total

  • Thread starter Thread starter walters
  • Start date Start date
W

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!
 
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!
Click to expand...

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.
 
Back
Top