excluding a record if information is entered in a query

J

Jennifer P

I am trying to create a query that will display only vessels that are in
dock, I can not figure out how to exclude a record if it has a time entry..

example

Vessel Pier Date In Time In Date Out Time Out
Andrew 10 03/22/05 07:00
Ms Ann 13 03/21/05 23:00
Toy 12 03/21/05 07:00 03/22/05 01:00
(Exclude this one)
 
K

Ken Hudson

Hi Jennifer,
In the criteria box for the time field enter "Is Null" to select those
records with no entry in that field.

Cheers.
 
Top