Query Transpose Help

[Badswell]

Hi,

I've attached a small JPEG file showing some query results and some data transposing I'm trying to work inside of Access. The top box shows the how my query results currently come up. The lower box shows how I would like to transpose this data so it can easily be exported to other things. I can handle the export part, but I am having trouble with getting the results to fit into my desired format while still in Access. I don't want to convert it outside of Access b/c that would add another step of things to do.

Any ideas would be appreaciated..

Thanks

 

[neileg]

I have a feeling that a cross tab query may get you some way down the road. Ultmately, you may still have problems exporting unless you joint this in a report and export that.

 

[Badswell]

That was my initial thought. The problem with that being the data is used purely as row headings in the export. There is no actual data fields to pull out. I think I may end up just using VB & work around it.