Thanks Remou
I probably didn't make myself clear but I don't need to know the values, just the number of records which are null.
DCount does this for me.
Thanks for the help.
My database has 2 tables, one for people and another for events for those people.
I need to check that a certain field on all the records in the second table for an individual has been completed before allowing a field in the other table to be updated.
I can write the query to do the checking...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.