Count "Text" Data

  • Thread starter Thread starter Bryan Hughes
  • Start date Start date
B

Bryan Hughes

Hello,

I am having trouble on how to do this query.

I have a table that holds Client Information, including [gender] type which
is denoted as M or F.

Each client has an CID.

Each Case File the client belongs to has a CFID.

I need to count the number of "M" in [Gender] per [CFID], and "F" in
[Gender] per [CFID].

How can I do this?

-TFTH

-Bryan
 
Create a Totals Query with the necessay fields .. add the Gender fiel
in the query twice and use Group By on one and Count on the other.

RD
 
Back
Top