View Full Version : add a query to my form


rudy78
02-11-2010, 07:03 AM
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.

SOS
02-11-2010, 07:14 AM
Use a DLookup as the control source:

=DLookup("FieldWithCount", "QueryNameHere")