select records by blank criteria

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

Guest

Access 2000
I wish to select records in an access select query that
(1) have no data in the criteria field
(2) includes all records that do not are not blank
 
hi,
not sure what you mean here. a blank record is not a
record and should not be selected. Do you mean not
containing blank fields.? if so then you will have to use
 

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

Access Dcount (multiple criteria) 3
Access Access Query Criterion 1
Selectively Update Field in Table 2
All-Record criteria in a query...hmmm 4
Using Variable as criteria 4
Need to cancel parameter criteria if prompt is blank 5
Query for 1st field, if blank then query 2nd field but not both. 6
Query criteria - exclude data and return all records if null 3

Back
Top