Can I create a query for missing info?

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

I need to create a query for a second user to fill in missing data without
have to look through records
 
That is rather vague.

Do you mean you want to show records where a certain field is blank?

If so, in the query enter criteria of Is Null under the relevant field.

If the field is a text field you may need to enter
Is Null or = ""
in order to handle either null values or zero-length strings (both of
which look like blanks, but are handled differently by queries).
'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
Back
Top