I have 2 tables: Member and Bulk Mail
I have linked them on Last Name
Member has these fields: First Name, Last Name, E-mail
Bulk mail has these fields: First Name, Last Name, e-mail address

The member table has no data in the E-mail field
The Bulk Mail table has data in the e-mail address field

I would like to update the Member E-mail field with the data in the
Bulk
Mail e-mail address field using the Query Wizard

Glenn

Glenn T. Dulmage
207 Valley Road
Chestertown, MD 21620
410-778-5166
gdulmage (AT) verizon (DOT) net

UPDATE Member INNER JOIN BulkMail ON Member.LastName=BulkMail.LastName
SET Member.Email=BulkMail.Email
Fred



On Apr 28, 1:45*pm, grin <gdulm... (AT) verizon (DOT) net> wrote: