False in a query (Access 2000)

Topic

New Reply

In my query i have an Yes/No field. With yes i mean paid and with No unpaid. When i put the crierua No in the query, i want to show all the orders that are not paid.However all the orders disappear even though they are unpaid.
What is wrong woth the false criteria ?

Reply | Quote

Replies

For most orders, there is no corresponding record in tblPaid, so Paid is not False for those records. It is non-existent. You can get around this by changing the criteria to

False Or Is Null

Reply | Quote

And i got around it indeed ! Thank you for the solution !

Reply | Quote