List fields which do not have a value in any of the records.

[VegaLA]

Hi all.
Having problems trying to list which fields in a table do not have any values in them at all. I thought this would be pretty straight-forwards but i'm having a nightmare trying to put this together. I wanted to create a query then use that as the source for a report.
The table has quite a few fields so i'm hoping there is some code that I can trigger from a button that will print this information for me.

Any help greatly appreciated!

Thanks in advance,
Mitch...

 

[The_Doc_Man]

No button exists that I know of. If you have n fields to check, you might have to write n queries. Or you could write VBA to step through the recordset and for each record step through the collection of fields to identify "empties." But that isn't all there is...

Your problem is further complicated by modes of comparison. If the field is numeric, did you want to see zeroes? If the field is text, you have both "empty" and "null" fields to consider as meeting your criteria. If you have default values in a field and the field is equal to its default value, does that count?

Think about these questions and try asking again.

 

[VegaLA]

OK Doc Man thanks.
At the moment i'm working through using qrys, counting the records of the table. I have got the report to show all the fields in the qry and now i'm just going to have the report display 'Missing' if the count = 0.

Thanks again.