Data Restructuring

[cdw0308]

I have a table that is setup with 3 fields

sequence, cable_num, and route

example data:

sequence cable_num route
1 10AB001-001 32413
2 10AB001-001 19485
3 10AB001-001 55521
4 10AB001-001 3e325
5 10AB001-001 5f452
6 10AB001-002 40285
7 10AB001-002 39484
8 10AB001-002 45e05


The sequence detemines the order of the route (asc order)
I need to be able to change this data to this format belwow in a query or into a new table.

cable_num route
10AB001-001 32413 19485 55521 3e325 5f452
10AB001-002 40285 39484 45e05

Any help would be greatly appreciated.

Thanks

 

[dhookom]

Check out faq701-4233.

Duane
Hook'D on Access
MS Access MVP