Query

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

walters

I have a query for orders shipped by date. Is there a formula to use to
total by month when running a report for the year. I want to report to show
total quanity for each month. Thnaks
 
I have a query for orders shipped by date. Is there a formula to use to
total by month when running a report for the year. I want to report to show
total quanity for each month. Thnaks
Click to expand...

Sure. Add a field to your Query by typing

ShipMonth: Month([Shipdate])

using whatever fieldname you use for the date. You can either use a Totals
query grouping by this field, or use it in your Report's Sorting and Grouping
feature to group by the month.
 
John W. Vinson said:
I have a query for orders shipped by date. Is there a formula to use to
total by month when running a report for the year. I want to report to show
total quanity for each month. Thnaks
Click to expand...

Sure. Add a field to your Query by typing

ShipMonth: Month([Shipdate])

using whatever fieldname you use for the date. You can either use a Totals
query grouping by this field, or use it in your Report's Sorting and Grouping
feature to group by the month.
Click to expand...
 
Back
Top