Report- order/invoice system- need help

  • Thread starter Thread starter amy Barton
  • Start date Start date
A

amy Barton

Using access 2002, need to create a report that will
dtermine number of products sold per customer per
specified time frame.

Example:
Abc Company June 1, 2004 to June 30, 2004
Product Qauntity Price Dollar Amount
Pens 1000 1.00 1000.00
Paper Clips 100 1.00 100.00
Total 1100 1100.00

DEF Company June 1, 2004 till June 30, 2004
Products Quanity Price Dollar Amount
Paper Clips 200 1.00 200.00
Paper 100 2.00 200.00
Pens 300 1.00 300.00
Total 600 700.00

Any assistance would be greatly appreciated.

Do not know what queries or tables to run.

Thank you
 
Hi Amy.
The first question is How do you have the data stored now.
I would assume you have a table for Company, one for
products and one for sales.
You than would create a query and Sort/Group by Company,
tahn by date and than by product. Than by filtering by
the desired date you could generate the report as you
described.
Hope this helps, if you need more answers, give some more
specific data to work with.
Hope this helps.
Fons
 
Back
Top