I have a form that displays statistics on a table using Dcount, including looking at missing data.
On a general point, why is the first parameter in the Dcount function required? Naming the table/query and the selection conditions is surely all that is needed?
I have created a number of counts successfully, but when I make a format error in the next one all of the previously correct ones now give errors, even when I delete the offending entry. I cannot understand why.
Finally, I wish to count the number of members who do not have an email address. The table is imported from an external system and the field is null if empty. There seems no way of doing this. Am I wrong?
On a general point, why is the first parameter in the Dcount function required? Naming the table/query and the selection conditions is surely all that is needed?
I have created a number of counts successfully, but when I make a format error in the next one all of the previously correct ones now give errors, even when I delete the offending entry. I cannot understand why.
Finally, I wish to count the number of members who do not have an email address. The table is imported from an external system and the field is null if empty. There seems no way of doing this. Am I wrong?