I have a Microsoft Access Table called Daily Door Access Rev B. This table has two Short Text fields – (1) Door No and (2) User No. Both of these fields contain numeric data only, but this is the table as I received it, as it is data imported from Excel.
Some of the table records are missing data in the Door No field and some are missing data in the User No field. Other records are missing data in both the Door No and User No field.
I am trying to create a Text Field in a Report Footer which counts the number of records in all three cases. I have been successful in counting the records for No Door No and No User No.
However, I have not been successful in writing a Text Box build statement which will count the records with both no Door No AND No User No.
I have a query which shows what the result of this text box should be, but I would like to verify this with a text box build statement. The query is shown in the attached PDF file.
Can you tell me what is wrong with my Text Box build statement, right now it is counting all of the records in the table.
=Count(IIf([Daily Door Access RevB]![Door No] And [Daily Door Access RevB]![User No]=" ",1,0))