and or statment

J

JRS

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>
 
D

Duane Hookom

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. ...
 
Top