Using Iif and eval in MS access

[aravindkm]

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.

My requirement is if the currency code is equal to GBP,USD,EUR,HKD the reporting currency column should have respective currency codes.

If other than GBP,USD,EUR,HKD the reporting currency column should have "OTH". While trying to implement this I used iif and eval function have had an 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 and also let me know what should be used.

Thanks

 

[aravindkm]

Hi Joe4,

Thanks for your response.

I have already tried joining the two tables however I require not matched lines also should be available in the query after joining the tables like in Vlookup we will not matched items as "#NA".

Like these I require the not matched items.

Thanks

 

[Joe4]

You would need to do a LEFT JOIN, which will show ALL the records from one table, and the resulting matching values from the other table (and blanks for the unmatched items).

See this link for details on how to do that: https://www.techonthenet.com/access/queries/joins2.php