Query(s) to deliver multiple counts from one table

[and]

HI - Can anyone help me with this....I'm am completely confused now....

Here's what I have:

Each record in client_table is a Client (ClientID is the primary key field)

Field names in question:
HighQlevel (has 9 possible text values... none, level1, level2, level3, level4..etc...)
Gender - male/female
BME - yes/no
Disab - y/n
LoneP - y/n
HomeL - y/n
Crim - y/n
Refugee - y/n
Asylum - y/n

What I need is to get a total Count of the number of records at each HighQlevel where:
Gender = female
BME = yes
Disab = yes
..etc etc

I need to see zero counts too, for example, if there are Zero females recorded at HighQlevel = level1

I'm trying to produce a resulting table such as this:

http://www.diminishingfish.com/sample_query_table.jpg

I want to be able to show this kind of information in a report... Am I barking up the right tree or is there a better way?

Thanks.
And.

 

[PHV]

Have you tried to play with a Pivot query ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[and]

No...thanks.....can you tell me a little more how a Pivot table would work?

A.