Access Report

D

Dazz

Hi,
I am trying to build a report from a query.
In it i have Customer, Product Code and a Quantity. I would only like to
show products that have a Quantity value Greater than 100 and Lower than -100
by customer.
This i can do in the query OK.

My problem is that i need to have a grand total of all the products, by
customer in the report and not just those values selected in the query above.

Is this possible?
Thanks in advance

Dazz
 
D

Davy

Use Excel in MS Office there you can create a spreadsheet, formattin
the columns and rows as required will allow you you add the total
and create Pie charts and queries etc

Dav
 
D

DL

I think you need two seperate queries then create the report, or possibly a
crosstab query for the report source.
Allthough I'm a little perplexed by, quantity >100 and <100
 
Top