Select Query Problems!!!

[RonnieDobbs]

Ideally this query should pull only "non-standard" from fees and only "std" or "none" from offlimits. However this is not the case. I tested this and altered a record in the one table this query is based on. I put "Blah" in the fees and "none" in the offlimits. the query picked it up? Why is the query showing this record??? How would I alter this code? This is driving me crazy.


SELECT [Confirm].[ID], [Confirm].[Fees], [Confirm].[Offlimits], [Confirm].[Office]
FROM Confirm
WHERE [fees]="Non-Standard" and [offlimits]="std" or [offlimits]="none";

thanks,

AB

 

[r937]

parentheses problem

you have

... WHERE x AND y OR z

because ANDs take precedence over ORs, this is evaluated as

... WHERE ( x AND y ) OR z

what you probably want is

... WHERE x AND ( y OR z )

therefore you have to code the parentheses explicitly

another option is to use IN(list) syntax

... WHERE [fees]='Non-Standard'
and [offlimits] in ('std','none')



rudy

http://r937.com/

SQL Consulting

 

[lespaul]

you probably need to group your conditions:

WHERE [fees]="Non-Standard" and ([offlimits]="std" or [offlimits]="none");


Leslie