Hey guys,

I need to run a report that lists critical field names left null for each record in a table. Assuming that SS#, Address 1, and PhoneNum are critical fields, if Record26 has nulls for SS# and PhoneNum, I'd like a row that says, "Record26 missing SS#, Phonenum".

The only thing is, I don't know how to query for the field names of null fields.

Can anyone help me out?

Thanks.