OR operator not working

  • Thread starter Thread starter Kevin11
  • Start date Start date
K

Kevin11

I don't see anything wrong with the expression. Is TXV a
boolean field type?

Drop just one AND condition and see if "S104" is
returned.

IIf(( ([EER]>=11 Or [SEER]>=13) And ([TXV]
=False)),"S104",...

If "S104" is returned than the problem is with the
condition you removed. You can test each condition this
way to see which one is the culprit. At least this will
narrow down your problem. Good luck.

Kevin
-----Original Message-----
I have this expression in my select clause. The query
Click to expand...
runs but the OR operator is not operating properly to
return the correct value:
....,IIf(( ([EER]>=11 Or [SEER]>=13) And (IIf([Product]
Click to expand...
="hp",[HSPF]>=8,[HSPF]>=0)) And ([TXV]=False)),"S104",...
 
I found out I had an inconsistency between the main select statement and the subquery - there was an "OR" specified for SEER in the main query, and an "AND" specified in the subquery. Problem resolved, thanks.
 
Back
Top