Count Records on a Form

[cbayardo]

Hi, I want to count records on a specific Field. For example, on a Employee
form, I want to know from the Gender Field how many males and how many
females are in that specific Form. I want to use that number later on for
another calculation.

Thanks

 

[John W. Vinson]

Hi, I want to count records on a specific Field. For example, on a Employee
form, I want to know from the Gender Field how many males and how many
females are in that specific Form. I want to use that number later on for
another calculation.

Thanks

A Totals query will do this. Select the primary key (any field that's never
NULL will do, but the PK fits that) and the gender field; change the query to
a Totals query; add whatever other fields you need to limit the records to
match those on the form; and Group By the gender field.

John W. Vinson [MVP]