If and Eval Function In Access

aravindkm

New member
Joined
Mar 13, 2014
Messages
19
Reaction score
0
Points
0
Excel Version(s)
2013
Hi All,

I tried using If and Eval function in MS Access while im getting the data in access however it is throwing a Syntax error.

The formula used is IIf(Eval([CURRENCY] In ("GBP","USD","EUR","HKD")),"AA","OTH") could anyone please let me know what's the issue with the formula I have used.

Thanks
 
Top