Query to Sum equal quantities

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I working on a Access Database for a friend and I have hit a dead end. This
is a DB of Customers with their personal details and Clothing size.

I have a simple table and a form to enter various info like name, shoe size,
shirt size and so on.


I want to create a query to give me the total of customers with the same
size so I will know how many of that size to purchase.

Like If I have 20 customers, 6 with size 7, 4 with size 8, 10 with size 9, I
want the report to state....

Shoe Sizes

Size Quantity
7 6
8 4
9 10

Thats basically it, I sounds so easy when you say it but to make it work
it's another story.

Thanks for all your help
 
Try the following

SELECT tblCustomers.ShoeSize, Count(tblCustomers.CustomerID) AS
CountOfCustomerID
FROM tblCustomers
GROUP BY tblCustomers.ShoeSize;
 
Back
Top