and or statment

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I used the logic below up unitl AND and it worked. When I added the 2nd
piece, it would not. Can you tell what is the matter with it? thank you


= If <Case Type Desc> InList ("DM-CAD" , "DM-Hypertension") Then "DM-CAD"
Else <Case Type Desc> AND If <Case Type Desc> InList ("CM-CAD" ,
"CM-Hypertension") Then "CM-CAD" Else <Case Type Desc>
 
I can't believe any of your expression works anywhere in a query. What is the
"=" used for? "If" is an expression available in a query. "<Case Type Desc>"
isn't a valid field name in a query. "InList" isn't a function. ...
 
Back
Top