Solved Create a query to find number of items in a table

[Sepp1945]

I have a table (see below) which has field "Product_ID", ( numbers 1 to 7).
I would like to create a query to give me in seven field the count of each product.
I tried but failed.
Thank you
Sepp

 

[theDBguy]

Why 7 fields? Try a crosstab query.

 

[Sepp1945]

Thank you

 

[theDBguy]

Thank you

You're welcome.

PS. Welcome to AWF!

 

[Sepp1945]

Thank you

Sorry does not work

 

[arnelgp]

you can join the product table (if you have) and do as advised in post#2.
this one does not have a product table:

TRANSFORM Count(tblPayments.Product_ID) AS CountOfProduct_ID
SELECT "Total Count" AS Remarks
FROM tblPayments
GROUP BY "Total Count"
PIVOT tblPayments.Product_ID In (1,2,3,4,5,6,7);

 

[Sepp1945]

This is perfect just what i needed,

Many, many thanks
Sepp

 

[theDBguy]

This is perfect just what i needed,

Many, many thanks
Sepp

Glad to hear you got the crosstab query to work. Thanks to @arnelgp for the assist.

Good luck with your project.