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
'====================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No data showing in query 4
just set up a 3-tab form but it won't let me enter data? just beep 5
How do I set up AutoLookup to automatically fill in fields for me 1
Counting multiple memberships 1
Save Query Results to Multiple Tables 6
Multiple Autolookup Queries on One Form 4
Date fields in access 3
totals button and missing records 1

Back
Top