Advertisement

03.31.2005 at 11:01PM PST, ID: 21372539
[x]
Attachment Details

Updating matching records in another table

Asked by isaacr25 in Microsoft Access Database

Tags: table, records, another, update, matching

I have two tables that have matching columns called "displayname." How can I update certain fields within the first table based on matching displaynames in the second table.

Table1
Table2
Common column: displayname
Fields that need to be update for matching records: email, telephone, pager, userid.

I hope this is clear. Thanks.

Start Free Trial
[+][-]03.31.2005 at 11:22PM PST, ID: 13678739

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]04.01.2005 at 07:03AM PST, ID: 13681370

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Access Database
Tags: table, records, another, update, matching
Sign Up Now!
Solution Provided By: shanesuebsahakarn
Participating Experts: 2
Solution Grade: B
 
 
[+][-]04.01.2005 at 02:21PM PST, ID: 13684962

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32