1: I do want to create a query that will that lists all the records - both CDN and USD
Code:
Select fields, currency from YourTable where currency in ("CDN","USD")
2: I'm going to add a field to the query that for the sake of this thread will be called [newcurrency].
I want the expression for this new field to look at the [currency] field of each record and if the [currency]= "CDN" update [newcurrency] to "CAD", and if the [currency] = "USD" then update [newcurrency] to "USD
Select IIF(currency = "CDN","CAN",Currency ) as NewCurrency from yourTABLE