I need to find out how to take a table in this format:
Column1 Column2 Column3 Column4 Column5
AA BB 1 2 3
AA BB 4 5 6
AA BB 7 8 9
And put the information into this format:
AA BB 1 2 3 4 5 6 7 8 9
I need to combine all records that have the same first two fields. In this example is turning three records into one. But this should be outputted to a Microsoft Excel spreedsheet and i am working in Access 97.
Any ideas would be very helpful because i have completely drawn a blank.
Thanks
Justin
