Hi guys. Im working with a database in access and have now found that I cannot do certain things without SQL so im trying my best. I basically I want to amend a field so that it includes the word 'credited' at the end. For example, if the value was originally 'Deposit Invoice', I would like to change it to 'Deposit Invoice Credited'.
The reason Im using SQL is because this is initiated from a different record from the same table with the use of a button. Anyway. I have this code:
Code:
CurrentDb.Execute "UPDATE Invoices SET InvoiceType='Credited' WHERE InvoiceNumber=" & YesNo
As you can see this will change the field to Credited but will not amend credited to the existing contents of the field.
I hope this makes more sense to you than it does to me. As always I really do appreciate any help I can get so many thanks in advance.