Thanks for all your help. I have chatted to an expert and apparently I need to use a VB command called DBGrid which goes over my head a bit. Your help was much needed and apreciated. Cheers!

[This message has been edited by willhays (edited 09-08-2000).]

A crosstab query might return the results you want. You can use this query as the recordsource for a form but there are two caveats. The data will not be updateable and if the column headings are changeable, you will need write code to take care of this. There is a sample report in either solutions.mdb or rptsmp97.mdb that uses this technique you can use as a model.

"Bridge players know all the tricks"

This may be too simplistic for what you are trying to do but depending on how large the table is you could copy it into Excel using the Edit/Paste Special command and then selecting the Transpose checkbox. After the columns and rows have been transposed you could import or paste it back into Access.