Nebie query question

[bartoni]

Hi, this is my first post so forgive me if its a bit simple....

Ive got a table with a list of product names in column 1 called "prd" and next to that column they are assigned a value of 1 or 2 (in column 2 called "Key"). How do I write a query that tells me how many products are in catogory 1 and how many in catogory 2. At the moment I only seem to get the total no. of prds. Ideally I would like the resulting Query to be:

Many Thanks,

Ian

 

[maxmangion]

you can do a Total Query, and use the 'group by', so that you can group by category.

 

[bartoni]

Hi

Heres the query and result (attached). Now I would like the count of prds side by side rather than on top of each other so that it has:

Prd Count across a row and then the varying keys (1 and 2) Key as the column eg.:

Key(1) Key(2)
Prd count 55 100


Is this possible?

Many thanks

Ian

 

[ColinEssex]

crosstab query

Col