Adding a field with corresponding records to an existing table

[BlueJacket]

I need to add an entire field's worth of records from one table to another, without adding new rows of records. Would the best way to do this be to use a create table query with all the fields and just replace the old table?

 

[plog]

I need to add an entire field's worth of records from one table to another, without adding new rows of records

Huh?

Specifically, "field's worth of records". You need to create a new field on an existing table and populate that new field with data? If that's not it, can you demonstrate your issue with data?

 

[sneuberg]

If you just need to add a field to a table and then populate it with the data from another table then just add the new field to the table and update it with an update query that has a join between the two tables

If this isn't clear then please post the structures of these two tables (Screens shots of tables in design view would be good), tell us what data is to be moved, and how the two tables are related, i.e, what fields in the tables can identify which records match.

 

[BlueJacket]

Sorry, I didn't do enough research. I just realized that I can put an expression in the "Update To" box and that was my missing link.