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