move value in column to row

[Avi]

I have a table that consist of GL account, cost, packing slip.
01501200100100 $57.71 093183
01501300100100 $71.51 093183
01501400100100 $137.92 093183

And need it in one row, is there a way to do it in access?



01501200100100 01501300100100 01501400100100 packing slip
$57.71 $71.51 $137.92 093183

Thnak you,

[June7]

Check this tutorial: http://www.datapigtechnologies.com/f.../crosstab.html

How many GL accounts are involved? As you will see from the tutorial, this can be done only if there is a small number.

[kennejd]

I would probably write some vba....loop through each record. I'm curious...why do you need to get the data in this 'single-line' format?

[Avi]

Thank you, crosstab will do it!

[Avi]

I need to to join the query to another table by the packing slip number.

[June7]

Crosstab might not be required in order to do that join. Still don't know what you are really trying to do. Possibly a report using Grouping and Sorting features would produce your desired output. Need more info if you want to explore options.