View Full Version : rows to columns


davidhutch
12-15-2001, 08:59 AM
Does Access have the ability to change rows to columns like Excel's Paste Special/Tranpose function?

I have a dataset well over 65,000 lines and have a need to use the change some rows into columns.

Thank you for your help.

-david

Pat Hartman
12-15-2001, 07:03 PM
A crosstab query might do what you need.