access newbie

  • Thread starter Thread starter Sul@MS
  • Start date Start date
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
 
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.
 
thanks for the response

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