Setting query criteria which only shows records that have a value in a field

[bomich]

Basically I have a date field called "Arrival Date" and I want my query to only show records which have arrived (and therefore have an arrival date).



I'm an access noob but I imagine it's quite a simple solution.. and I'm being quite simple. I just can't think how to do it!!

I can query the opposite (e.g. Criteria: Is Null) is there a reverse like "Is Full" or something...?!

Thanks.

[JoeM]

Whenever you want the reverse of something in Access/SQL, "NOT" is the word to remember, i.e.
Criteria: Not Is Null

[bomich]

Ahh.. I thought it would be something like that.

Thanks Joe!