count either male or female from one column in query

  • Thread starter chedd via AccessMonster.com
  • Start date
C

chedd via AccessMonster.com

Hi

I have a column in access which records either male or female from a drop
down menu. I would like to run a query to show how many females and males we
have recorded. At present i only know how to do a toatal count of both?

Please can you help or irect myself in the right direction.

Thanks

Chedd
 
K

KARL DEWEY

Use two calculated fields in a totals query --
Male: Sum(IIF([Gender]="M",1,0))

Female: Sum(IIF([Gender]="F",1,0))
 
Top