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