My boss has requested a report of all records with null fields, and a list of all null fields in each record. For example: Record151 has fields X,Y,Z null; Record235 has fields J,K,L null.

Any ideas on how to do this without having to "hardcode" each field name into the script. There are probably about 150 fields per record (database keeps records of doctor credentialing data).

I was thinking I could do some kind of script that basically used CASE and a loop to check each field of each record and use Get (ActiveFieldName) and Get (RecordID), but I was hoping I wouldn't have to select every field name in the CASE calculation by hand. Is there a way to chek each field in a record without manually choosing each field and "hardcoding" it in the CASE calculation? I'm looking for something more abstract.

Thanks in advance for any help.

Sol

Edited January 25, 200718 yr by Guest
Tried to make it more clear

Hi

try this. ( No field's name )

It can be easily suited to your needs; take that only as a starting point ;)

FindEmpty.zip

That is a very strange request. The need for this suggests there's a problem with the data structure.

There is a good reason for it. She wants to send the reports to each doctor and make them accountable for getting us the information that is missing. First, however, she needs a report that let's us know what is missing. ???

Perfect!!

Thank you so much. I really appreciate the help.

Sol