How to append to column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have Table A and Table B, and a query. The query includes all of Table A
and one additional column from Table B. How can I append the new column back
(looping it) back onto Table A? The append feature only adds rows the bottom
of Table A, which isn't my intention.
 
Are you saying you want to add a new field to TableA instead of a new record?
You cannot append fields using queries. Fields are part of the table
structure, not part of the data it contains. There are ways in VBA to create
fields dynamically, but generally you want to control table structure
separately from data input processes.

If you just need to create a new field in TableA & then populate it with
some data from TableB, then manually create the field and write the query to
append or update the data in the new field.
 
Back
Top