Finding any blank fields in a set of records

[lefkovj 0]

I have a database with >50 fields. All fields should have an entry in them. For auditing purposes, I need to find if any field in any record has been left blank.

Is there a way of listing the records (and possibly the fields) in which there is at least one field that has been left blank.

Thanks for the help.

[Vaughan 103]

I cannot think of a "quick and easy" method. Just a script that performs a find for empty values in each and every field, all 50+ of them..