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
 
Back
Top