Prev: using fsubNavigation form with only setting record source at gotfocus
Next: Forcing page breaks where you need them in subreports
From: grin on 28 Apr 2010 16:45
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(a)verizon.net
From: zuckermanf on 30 Apr 2010 04:22
UPDATE Member INNER JOIN BulkMail ON Member.LastName=BulkMail.LastName
SET Member.Email=BulkMail.Email
Fred



On Apr 28, 1:45 pm, grin <gdulm...(a)verizon.net> wrote:
> 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
> gdulm...(a)verizon.net

 | 
Pages: 1
Prev: using fsubNavigation form with only setting record source at gotfocus
Next: Forcing page breaks where you need them in subreports