0
I would like to run a query that updates a field's value with whatever is already there but with an "cbt" appended in the end.
For example say there's a field called Currency
and for a certain record Currency
is "USDCNY"
, I want the field Details
to be updated to whatever is in the field plus "cbt"
at the end.
Ideally I would like to add this to the query in the Criteria
line of a field called Details
. I have tried something like this in the Criteria
line of the field called Details
. But it isn't working.
IIf([Currency]="USDCNY",Update[DETAILS],+'cbt')
Where is the update? – yass – 2017-06-09T20:32:31.683