Combine Two Records into One

[Dave F]

How can I combine two records into a single record in a new table?

The table has two fields, Unique Record ID and Text String.

The second record is always a continuation of the first record.

For example:
ID Text
1 Text string record 1
2 Text string record 2
3 Text string record 3
4 Text string record 4
....
n Text string record n
n+1 Text string record n+1

The result needs to be (in a new table):
1 Text string record 1 Text string record 2
2 Text string record 3 Text string record 4
3 Text string record 5 Text string record 6
....

Thanks,
Dave F.

 

[Graham R Seach]

Dave

INSERT INTO Table3
SELECT (Table1.[Text] & Table2.[Text]) As [Text]
FROM Table1
INNER JOIN Table2
ON Table2.ID = Table1.ID

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html