Query

[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

 

[John W. Vinson]

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

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.

 

[Frances LeMay]

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

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.