Microsoft Access Report Column Headers

Question

Hello,

I am trying to create a report in Access that runs off of a crosstab query. I basically want it to display like the crosstab query results. I need the store_names on the left and the cust_numbers on top as column headers and the count of orders. The store_names and cust_numbers will change daily. I'm having trouble figuring out how to do the column header portion. Any help is greatly appreciated.

Thank you,

James

Answer 1

This is a link to the zip file.

There is a table "ztblExplanation" with some information about the report.

Let me know if you have any questions.

Answer 2

I have a demo at http://www.rogersaccesslibrary.com/forum/cross-tab\_topic11.html but it is too old for even me to open. You might be able to. If not, I can phone a friend to do a quick conversion for me.

I am unable to open it as well. "Cannot open a database created with a previous version of your application." Can you phone that friend?

Thanks,

James

Answer 3

I have a demo at http://www.rogersaccesslibrary.com/forum/cross-tab\_topic11.html but it is too old for even me to open. You might be able to. If not, I can phone a friend to do a quick conversion for me.

Answer 4

Thanks HansV. I will check that out.

Answer 5

A dynamic crosstab report is quite complicated. See for example Dynamic cross-tab (and report)