excluding a record if information is entered in a query

[Guest]

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)

 

[Guest]

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

Cheers.

 

[Guest]

It keeps giving me a "Data Type mismatched in criteria expression"

Thanks
Jen

 

[Guest]

Ken Figured it out... DAH you were right on thanks...Jen