Monthly Total in a Report

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
 
D

Duane Hookom

It would really help if you (or your boss) entered some sample records and
how you would expect them to group and total.
 
A

Annelie

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
 
Top