Count "Text" Data

[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

 

[R. Hicks]

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