Crosstab query report

[amigos]

Hi there,

I have Access report that is based on Crosstab Query. It shows all weeks of this year as columns headers and sales figures in these weeks. Now the problem is: when I designed report there were 43 weeks and I put 43 columns into report when I designed it. Now I have to update this every week (put one more column to report so it shows new week) - is there any way to automate this. Obwiously this query always shows current number of weeks, but how can I update number of columns in Access report?

thanks in advance for any help

 

[SydneyGeek]

Sounds like a pain to update. Just a thought... if you changed the orientation so the weeks were row headers and the sales are column headers (or values), would that work? That way, additional weeks would just generate additional rows with no change needed for the column layout of the report.

EDIT -- maybe this link will help: HOW TO: Create a Dynamic Crosstab Report in Access 2002
http://support.microsoft.com/default.aspx?scid=kb;en-us;328320


Denis

 

[bat17]

Or convince them that they really need a rolling 52 weeks

Peter

 

[amigos]

thanks for link SydneyGeek,
I already found it last Friday and it works fine.
so my problem is solved

I just thought that there might be some non-VBA way to do this, the idea of transposing query wouldn't work as number of employees changes as well,

Thank you for your time guys