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