Vlookup function in Access?

I have 2 tables in Access 2002 - user_details and email_addy.

The primary key in each table is the same. I would like the "email" field from "email_addy" to appear in the "user_details" table. I will then delete the email_addy table.

How can this be done?

Yes

First Create you new field in the UserDetails table

The exectue the following SQL statment from a query

UPDATE Table2 INNER JOIN Table1 ON Table2.FieldOne = Table1.Field1 SET Table2.FieldTwo = [Table1]![Field2];


S-

I managed this by doing an Update Query in the end via the wizard. Thanks for the reply though, much appreciated.