Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > Combining two t...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 30169 of 30803
Post > Topic >>

Combining two tables with no duplicate names

by Don Barton <DonaldB627@[EMAIL PROTECTED] > May 5, 2008 at 11:59 AM

I have 2 tables, Table 1 has Name, NameID, and A, B, C fields.
Table 2 has Name, NameID, and D, E fields.
Several of the Names/NameID are the same in both databases.  I want my
merged the tables so each record looks like; Name, NameID, A, B, C, D,
E.  I have merged them successfully but I am getting two records for
each name, one record for A, B, C fields, and another record for the
D, E fields.

Example,
Name           NameID      A     B    C     D     E
Smith, John     123          X            X
Smith, John     123                               X      X

What I want to see is:

Name           NameID      A     B    C     D     E
Smith, John    123           X           X      X     X

Thanks,

Don
 




 3 Posts in Topic:
Combining two tables with no duplicate names
Don Barton <DonaldB627  2008-05-05 11:59:28 
Re: Combining two tables with no duplicate names
Marshall Barton <marsh  2008-05-05 14:13:57 
Re: Combining two tables with no duplicate names
Don Barton <DonaldB627  2008-05-08 11:01:11 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Fri Jul 25 5:33:49 CDT 2008.