Try looking into crosstab query.

"Mark" wrote:

Can anyone tell me how to make a table that transpose columns to rows in an
access query? I don't want to have to send it excel, transpose it and then
re-import it to Access. I would like to beable to do it all in access.
Thanks for your help!!!

MG