I have a question whether you can use a query to find who has paid for an order and who has not paid. I use the nil or not nil to get this? Thank you for your attetion to this matter. Raul
Reply from Richard Rost:
I would make an IsPaid field which is a Yes/No value. Then you can just make your query criteria for this field "Yes" or "No" depending on which you want to see.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 5.
