Merge records

[openroad]

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

[puppydogbuddy]

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

[openroad]

Thanks! Perfect! Worked like a charm after some study and a few mishaps