I would like to run a query that updates a field's value with whatever is already there but with an "n" appended in the end.
For example say there's a field called
AccountNumber and for a certain record
AccountNumber = "IP1234", I want it to be updated to
I imagine the query to be something like
UPDATE (Accounts.AccountNumber) = ([Accounts.AccountNumber] & "n") WHERE Accounts.AppendNumber = TRUE;
but with the correct syntax.
Thanks in advance