Populate blank table with all values from another table

cjcobra

Registered User.
Local time
Today, 01:54
Joined
Jan 14, 2011
Messages
25
I've been searching and can't find any answers. I have two tables (Table 1, Table 2). Table 1 is blank and has the fields "Field1, Field2, and Field3." Table 2 has data and 10 different fields ("Field1, Field2", etc). I want to copy all data from the matching fields in Table 2 to the corresponding Table 1. I've tried an Update Query in design view. Did not join any records, and just a simple:

Field: Field 1
Table: Table 1
Update To: [Table2]![Field5]

This returns 0 records to update. I thought about a Make Table to override the entire Table, but that isn't working either. I thought this would be simple, but seem to be struggling. Thanks for any help!
 
I understand what you want to do but can you explain the need
 
I figured it out. Access makes it difficult to start with an Update query. I had to make a Select query first, drag my field down, change to Update, then choose the dropdown for Update To.
 

Users who are viewing this thread

Back
Top Bottom