I need to copy the data from one column and add it to the existing text in the column next to it in the same table. I'm sure this is a very simple VBA, but I have no idea how to do it. Can someone please help a beginner?
I need to copy the data from one column and add it to the existing text in the column next to it in the same table. I'm sure this is a very simple VBA, but I have no idea how to do it. Can someone please help a beginner?
It is not usual for two fields (columns) in the same record to have the same value. Please tell us more about what you are doing.
Sorry, it made sense in my head Okay so I have an address that has been split into two columns. One column has the house number (e.g., 100, 200, 300, etc.) The next column has the rest of the address (e.g., E. Knight Ave.) I just want one column with the whole address 100 East Knight Ave. 200 East Knight Ave. etc. So I need to take all info in column B to column A with a space after the number so that it can be used in an invoice. Is that more helpful?
Yes, but you do not need to use up a field (column) for this, you can simply use a query with a calculated (concatenated) value. FullAddress = StreetNumber & " " & StreetName
Is it easier to write all the queries that way or to actually fix the problem. I would just do it manually, but there are 600 entries. I would like it to be a permanent change and then just delete the second column.
I tried this, but it didn't work
Sub mycode()
CurrentDb.Execute "INSERT INTO House(HouseID) SELECT House(Address)"
End Sub
I would strongly recommend you leave your fields the way you have them. The one query will work for all records in the table.