add a query to my form

rudy78

Registered User.
Local time
Today, 16:35
Joined
Feb 8, 2010
Messages
16
I like to count all the records that have a True (Yes/No) returned on a checkbox.

e.g. All customers that have been 'checked'.

I like to have this single number come up on my form.
 
Use a DLookup as the control source:

=DLookup("FieldWithCount", "QueryNameHere")
 

Users who are viewing this thread

Back
Top Bottom