By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,804 Members | 1,627 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,804 IT Pros & Developers. It's quick & easy.

Merge records

P: 2
Does anyone know how to merge similar records into one record?

Example;



Table 1

FName LName Data 1 Data 2 Data 3 Data 4
Joe Smith 1 2

Table 2

FName LName Data 1 Data 2 Data 3 Data 4
Joe Smith 2 3 4


Desired query output
Table 1-2

FName LName Data 1 Data 2 Data 3 Data 4
Joe Smith 1 2 3 4
Dec 11 '07 #1
Share this Question
Share on Google+
2 Replies


puppydogbuddy
Expert 100+
P: 1,923
Does anyone know how to merge similar records into one record?

Example;



Table 1

FName LName Data 1 Data 2 Data 3 Data 4
Joe Smith 1 2

Table 2

FName LName Data 1 Data 2 Data 3 Data 4
Joe Smith 2 3 4


Desired query output
Table 1-2

FName LName Data 1 Data 2 Data 3 Data 4
Joe Smith 1 2 3 4

See this link:
http://office.microsoft.com/en-us/ac...860631033.aspx

Click the hyperlink
Append data from two or more similar tables or queries into a single table
Dec 11 '07 #2

P: 2
Thanks! Perfect! Worked like a charm after some study and a few mishaps
Dec 12 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.