Query to Sum equal quantities

[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

 

[David Ferguson]

Try the following

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