Monthly Total in a Report

  • Thread starter Thread starter Aurora
  • Start date Start date
A

Aurora

I am using Access 2000

I have a report sorted by Quote number field with date
field in assending order. Each quote may have more than
one type of product on it. There are $$ field by product
and total by quote. My boss wants to be able to run this
report for any time period and see $totals by Month. How
do I do this?? I have no idea. I can total by Quote No
and I can total by report but I do not know how to total
by Month.

Can anyone help me?????

Aurora
 
It would really help if you (or your boss) entered some sample records and
how you would expect them to group and total.
 
In the query for the report insert a field like
SalesMonth: DatePart("MMM"",[yourdatefield])
In the Report under sorting and grouping insert the salesmonth with footer.
The footer with give you the total by month, or rerun the wizard
 
Back
Top