Query criteria: field is empty

P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates 1
Access 2000 query criteria 6
Results from criteria field incorrect although syntax used are the 1
problem with criteria in query 3
Date criteria 9
Date search query 0
Query Criteria IIf statement 4
query using an expression 7

Top