Problem with Multiple OR

  • Thread starter Thread starter jc.vega via AccessMonster.com
  • Start date Start date
J

jc.vega via AccessMonster.com

I am trying get a result using the following WHERE statement, which doesn't
work - or should I say, doens't give the correct result.

WHERE Fields.fLabsCutoff<#12/18/2006# And (Fields.fCBC=Yes) And (Fields.
fCBCReceived=No) OR (Fields.fChem7=Yes) And (Fields.fChem7Received=No) OR
(Fields.fXRAY=Yes) and (Fields.fXRAYReceived=No);

If I do the following it works fine:

WHERE Fields.fLabsCutoff<#12/18/2006# And (Fields.fCBC=Yes) And (Fields.
fCBCReceived=No);

Any help given is much appreciated.
 
What exactly are you looking for? And has a higher precedence than Or. You
might need to include some parentheses:

WHERE (Fields.fLabsCutoff<#12/18/2006# And (Fields.fCBC=Yes) And
(Fields.fCBCReceived=No))
OR ((Fields.fChem7=Yes) And (Fields.fChem7Received=No))
OR ((Fields.fXRAY=Yes) and (Fields.fXRAYReceived=No))

That will retrieve rows where the first line is true or the second line is
true or the third line is true.
 
Basically there are 10 checkbox controls on my form one to check if something
was sent and one to check if it was received. I needed a query that will show
every record that has a check on Sent and not one received, by a specific
date.

Adding the parentheses didn't help. I actually have tried it every which way
I could think of.

Anyone else have any ideas?

What exactly are you looking for? And has a higher precedence than Or. You
might need to include some parentheses:

WHERE (Fields.fLabsCutoff<#12/18/2006# And (Fields.fCBC=Yes) And
(Fields.fCBCReceived=No))
OR ((Fields.fChem7=Yes) And (Fields.fChem7Received=No))
OR ((Fields.fXRAY=Yes) and (Fields.fXRAYReceived=No))

That will retrieve rows where the first line is true or the second line is
true or the third line is true.
I am trying get a result using the following WHERE statement, which doesn't
work - or should I say, doens't give the correct result.
Click to expand...
[quoted text clipped - 9 lines]
Any help given is much appreciated.
Click to expand...
Click to expand...
 
Parentheses are your friend.

WHERE Fields.fLabsCutoff<#12/18/2006# And
(
(Fields.fCBC=Yes And Fields.fCBCReceived=No)
OR (Fields.fChem7=Yes And Fields.fChem7Received=No)
OR (Fields.fXRAY=Yes and Fields.fXRAYReceived=No)
)

By the way, strange name for a table - Fields
 
John, thank you. You are right, Parentheses are my friend now. It worked
great!

Yeah, I agree the naming structure is strange. However it's too late to go
back and change everything.

Thanks again.

John said:
Parentheses are your friend.

WHERE Fields.fLabsCutoff<#12/18/2006# And
(
(Fields.fCBC=Yes And Fields.fCBCReceived=No)
OR (Fields.fChem7=Yes And Fields.fChem7Received=No)
OR (Fields.fXRAY=Yes and Fields.fXRAYReceived=No)
)

By the way, strange name for a table - Fields
I am trying get a result using the following WHERE statement, which doesn't
work - or should I say, doens't give the correct result.
Click to expand...
[quoted text clipped - 9 lines]
Any help given is much appreciated.
Click to expand...
Click to expand...
 
Back
Top