Re: Problem with Multiple OR

Tech-Archive recommends: Speed Up your PC by fixing your registry

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?


Douglas J. Steele wrote:
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.
[quoted text clipped - 9 lines]

Any help given is much appreciated.

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: Check for table name
    ... Douglas J Steele wrote: ... figured out that the parentheses is a boolean comparison. ... I added the parentheses in an attempt to make it easier to understand ...
    (microsoft.public.access.formscoding)
  • Re: Message Box Error
    ... There are two different modes for MsgBox. ... When you include the parentheses, it's a function that returns a value, so you have to assign it to something. ... Doug Steele, Microsoft Access MVP ... "JamesJ" wrote in message ...
    (microsoft.public.access.formscoding)