How do I find blank fields in an MS Access database?

[Guest]

I would like to search the same field in every record in teh database to make
sure it is not blank.

 

[fredg]

I would like to search the same field in every record in teh database to make
sure it is not blank.

You could create a query showing all the records.
As criteria for the field you wish to check use:
Is Null

Only the Null records will be returned.

You could also use your Form's 'Filter by Form' or 'Filter by
Selection' tool button to filter for all the Null records.

 

[John Nurick]

Hi Siggie,

Use a select query with a criterion of
Is Null
on the field in question.

The SQL view of the query will look like this:

SELECT * FROM MyTable
WHERE (MyTable.MyField IS NULL);