Applying a Filter with CountRows

[mckenneyj]

I have a query for the report that returns 100 rows
2 Fields CaseNo CloseDate
Of the 100 rows only 32 have a CloseDate
Need to perform a count where CloseDate Not Null

Thanks,
John McKenney
Work Hard... Play Harder

 

[xlbo]

Add a 3rd field to the query

isnull(Field2,1) as counter

then simply use "counter" as your count

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question