Beginner question

[Guest]

I am creating a query that counts how many times each classification is being
used in our organization. But, I need it to pull up only the classifications
that have a person in them. Here's how it looks now:
Column 1: Field = Classification; Table = pos info; Total = Group By
Column 2: Field = Class Code; Talbe = pos info; Total = Group By
Column 3: Field = Count Of Classification: Count(*); Total = Expression

I need it to pull up the Classifications that, within each same record, the
field "IncumbentLast" Is Not Null. Thanks for your help.

 

[J_Goddard via AccessMonster.com]

Hi -

Add the field "Incumbentlast" to the query, put Total=Where, and put "Not
Null" as the Criteria.

John

 

[John W. Vinson]

Add the field "Incumbentlast" to the query, put Total=Where, and put "Not
Null" as the Criteria.

small correction: the criterion needs to be

IS NOT NULL

or

NOT IS NULL


John W. Vinson [MVP]