Update query

[mohd21uk via AccessMonster.com]

I have two tables one is called tbl Employee while the other is called tbl
Contacts. I have two fields called First Name and Last Name in tbl Employee
and in tbl Contacts. Tbl contacts contains an additional field called Email
Contacts. I have used a select query to select A matching First Name and Last
Name in both the tables with the matching email address. I would now like to
update tbl Employee with the matching email address for which I have created
a new field in tbl employee called email address. Is there any way that this
can be done ?

Many Thanks.

 

[John Spencer]

You should be able to convert the select query to an update query.

Open the Select query in (grid) design view,
Select Query: Update Query from the menu
In the Update row under the new field enter [tbl Contacts].[Email contacts]
Make sure the rest of the update row is blank
Select Query: Run from the menu (simply switching to the data grid does not
run the update query)

By the way, you do know, that matching on just First and Last Name is
problematic. There are a lot of people that share the same names.

If the above doesn't work, you can post the SQL of your current query and
someone should be able to modify it for you to make it into an update query.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message