I am an Access novice and I cannot figure out how do the following:
Table_1 contains email addresses. Table_2 contains email addresses and zip codes. I would like to add the zip codes from Table_2 to any matching email addresses in Table_1. It is imperative that no new email addresses be added to Table_1, just zip codes.

I'm not really sure what I need to do. Do I need to run an update query, and if so, what is the best way to do that?

Thanks in advance for any help!

Elena

Ad both tables to the QBE grid. Drag and drop between the two fields (one in table1 and one in table2) that match (Email?).
Select query, Update from the menu to convert the query from a select to an update
Drag the field you want to PUT the zipcode in to the grid
Enter the field name for the zip code from Table2 in the UPDATE TOO field, best to include the table name in the format Table2.ZipCode
See if that works for you