Counting the actual number of results froma query

[peterpos]

hello
sorry if this is very basic knowledge but I cannot figure out how to do this with my client database
I have a query that gives me gender (male, female, and unknown)
with the corresponding status of each person ( positive, negative or not known)

I wish to get the total number of each ie

males who arepositive
male who are negative


male who are unknown
female who are positive
female who are negative
female who are unknown
unknown who arepositive
unknown who are negative
unknown who are unknown

my query just gives me each clients gender and status
But how do I get a total number for each group

thanks for any assistance
peter

[orange]

Please show us your query sql.

see http://www.w3schools.com/sql/sql_func_count.asp

[peterpos]

Please show us your query sql.

see http://www.w3schools.com/sql/sql_func_count.asp

here is a screen shot of the query

[orange]

Remove the discharge date from the grid,
add clientID to the grid
and select Count in the Total Line.

Try it and let us know

[peterpos]

thanks
that works perfectly

[orange]

Happy to help. Good luck.