Really simple question

  • Thread starter Thread starter dmlippert
  • Start date Start date
D

dmlippert

I want to create a query that gives results that have data in numerous
fields. What is the "Criteria" I would put to find all entries that are
not NULL?
 
In the query design mode, in the criterion row, beneath each field that you
wish to restrict to not null, type in "Not Null" (without the parentheses).

If you want only records when ALL are not null, put the "Not Null" in one
criterion row.

If you want any records when ANY are not null, put them in separate
criterion rows.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top