select records by blank criteria

G

Gerry. Vaughan

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
 
G

Guest

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
 
Top