Access reports

[swoozie]

I need to beable to build a report based on a crosstab query where the column heading change based on a user input date range. I have been unable to locate any reference material on this and am looking for assistance.


Thanks,

Swoozie

[Mandelbrot]

Swoozie,


This is not easy, unfortunately. If you have a fixed number of columns then this isn't so bad - you name the control's data-source on the report to be the same as the column in the cross-tab. The problem comes when you have dynamic columns. One way around this is to restrict the data the user can see, thus giving you your fixed column heads. You may still need to programatically drop the column names into the text controls on the report, though.

Cross-tab queries are EVIL, though, and should be banished from the face of the planet, or strapped to Bin Laden's backside and hit with a rocket.


Hope this helps ... (even in the slightest!)

[Mandelbrot]

Sorry I haven't got back to you Swoozie. Just a quick note for you. Creating queries then deleting them can dramatically increase the size of your db. Be sure to compact at least once a month if this is a big db, and even more frequently if it is huge...