access newbie

S

Sul@MS

Using Access XP;

I have 2 fields; Customer and Sales

Customer Sales
123 100
456 200
789 100
123 500
456 300
789 200

How do I go about query or report to find;

1. The total amount of Sales for Customer 123
2. The Customers whose Sales exceed 500

tia
 
R

RonaldoOneNil

Create a query using the query design grid. Put your customer field in column
1 and your sales field in column 2. Click on the Sigma/Totals button on the
toolbar. Leave your Customer field as Group by but change the Sales field
from Group By to Sum.
Run the query.
Repeat the above for your 2nd query but add >500 in the criteria row of your
sales column.
 
S

Sul@MS

thanks for the response

to obtain a report of all customers and sales, do I use the Report?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top