Multiple counts

[Wildster]

Hi,

How can you count x and y as seperate counts from the same field?

i.e. A table has the field Gender and I want to have one count which counts the number of records with 'male' as the gender' and another count which counts 'female' as the gender?

Any help will be very much appreciated

[ChipR]

Make a query and set it to Totals. Add the Gender field and set Total: Group By, then add the Gender field again and set Total: Count.

[DonRayner]

Or you can use the DSum() Function

DSum("[Gender]","YourTable", "[Gender] = 'y'")

Replace YourTable with whatever your table name is.

[Wildster]

Thanks guys, big help