aravindkm
2017-09-26, 10:14 AM
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
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