Find Only Blank Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that user enter their info except for an Aisle field (they
don't know where) and then 1 other user needs to go and find all the records
that don't have the Aisle field complete and she will enter that information.
How can I do a query that will only show records that are empty in the aisle
field? Thanks.
 
In query design view, in the Criteria row under the Aisle field, enter:
Is Null
 
You must log in or register to reply here.

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

Sort on multiple levels 5
tableadapter Query linked to Access 2003 table 1
Macro Assist 2
Autofill Form Fields 1
Need to assign data into a table automatically 1
ComboBox Writing to First Record 2
Access Automatically Send a notification email once a record is added 0
Calculations in Access and Excel don't match 2

Back
Top