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
 
R

RJ119

(1) have no data in the criteria field

If you are looking for records with blank fields in the criteria for the
field you want to check enter: Is Null

(2) includes all records that do not are not blank

If you want to see just records with a value in a field. In the criteria
line of that field just enter: Is Not Null


Hope this helps
 
Top