Query criteria: field is empty

[paulkaye]

I'm sure this has been asked before but I can't seem to create a
successful search for it.

I'm trying to generate a simple query which brings up all records
where field X is empty. In reality, this is the "Invoice paid" (date)
field and the query will bring up all unpaid invoices.

Any suggestions?

Thanks,

Paul

 

[Allen Browne]

In query design, in the Criteria row under this field, enter:
Null

 

[paulkaye]

Perfect - thanks!

In query design, in the Criteria row under this field, enter:
Null