Multiple Criteria in Query Not Working with Or - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Multiple Criteria in Query Not Working with Or

Gary Becker

10 months ago

I'm wondering what I'm doing wrong. I want to NOT include any Transaction Type that is "Dollars Paid" or "Cash Receipt". If I do only one of those it works. If I add the 2nd criteria to the grid neither works--it includes both of them in the results.

	Gary Becker OP @Reply 10 months ago

	Adam Schwanz @Reply 10 months ago
That's because of the OR and <> means Cash Receipt is OK for showing Dollars Paid, and Dollars Paid is ok with showing Cash Receipt. Instead do it on one line, <>"Dollars Paid" and <>"Cash Receipt"

	Sami Shamma @Reply 10 months ago
Post the SQL for this query.

	Adam Schwanz @Reply 10 months ago
Another way to think of it is if we pretend only 5 numbers exist, 1-5 <>1 would say its ok to show 2,3,4,5 OR <>2 would say its ok to show 1,3,4,5 Thus you get everything, 1,2,3,4,5

	Gary Becker OP @Reply 10 months ago
Thanks. I've struggled with this and never could figure out WHY. My brain was say show everything that doesn't equal (this) or (this) And it looks like the keyword is AND instead of OR.

	Gary Becker OP @Reply 10 months ago
This is the SQL that works.

	Gary Becker OP @Reply 10 months ago

	Alex Hedley @Reply 10 months ago
AND across OR down

	Stanley Mc Keown @Reply 10 months ago
Another thanks to Adam as this is useful to know and I haven't had the cause to use it yet but may do in the near future so just bookmarking this thread.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View