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
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