? Confused about ONLY

[Poot]

Hello,

I am trying to run a query that will only pick up records that have a specific field filled. i.e. i have a field that will be filled with a cancellation date uopn someone cancelling a booking.

My problem is though that when I run my query it just picks up all the records... how can i filter to only pick up ones with my cancelled field filled with a date? This criteria is what I am unsure of.

Should I be trying to do this with a report instead?

Thank you for any reply,

Regards,
Poot.

 

[jfgambit]

Add Is Not Null to the criteria of the Cancellation Date field

 

[Poot]

Yay!

Thats the one... something so simple!!

Thank you.

+karma to you!!

Regards,

Poot.