You can use a select query. If you are using the query builder, use the
Criteria rows. In the column for each field you want to check, type in Is
Null. But, don't put them all on one row. Everything on a row is an AND
condition. Put them all on separate rows. When you use multiple rows, each
row is an OR condition.
If you are using SQL, then you need to string OR conditions for each field
you want to check in the WHERE predicate:
WHERE [field1] Is Null OR [field2] Is Null OR [field3] Is Null
The result of the query will produce a row for each record that has one or
more null values in a field, but you will have to visually identify which
field(s) in each row is null.
AnubisAscends said:
I would like to use a select query to find all of the fields in a table that
are a null value. Can I do this with one query, or do I need to create
multiple queries, or do I have to use VBA to do this.
Any help is appreciated.