How do I create a report for error checking my table

[irethedo]

Even though I think I have made my forms bullet proof, from time to time I find records in my table containing blank fields where I should have data. I would like to create an error checking routine that will check the table for certain blank fields and create a report and then email it to the person requesting the report or a support person.

I am using Access 2003 and I know how to do the report but I unsure how to set up the query.

Obviously using "=NULL" in the query criteria field for all fields where I want to find blanks will only show records where all of these fields are blank, right? How can I search for record that has any one (or combination) of fields that are blank?

Also, I had heard that it is possible to email a report like this to a support person automatically, so that a person would request a table error check by clicking a button on a form and then recieve an email with a report attached which details records in the table which contain blank fields.

Is this possible and if so, can anyone detail how I might impliment such a feat?

Thank you.

 

[mp9]

Search Access Jet SQL Help for the OR command, as in...

Field1 Is Null OR Field2 Is Null OR Field3 Is Null....

For emailing the report at the click of a button, search Access help for the SendObject method/action which can be used to send a db object (including reports) by email...