Column Updating

[DoleseII]

All, I spent a good bit of time developing some cross tab queries in MS Access (they are quite simple.) 1 set of row Headings, 1 column heading, and 1 set of data.



The column heading is the last 14 weeks. and the data is just a percentage of X of each week.

Every week the 14 weeks change of course. For example column titles -
column 1 = 7/24/17
column 2 = 7/31/17
etc.

Next week Column 1 will equal 7/31/17.

The query works fine, however I did a MS Query, to bring that Access query into excel. Excel will not update currently because it is looking for the same column titles as last week..... I'd like it just display what is in the Access query...... I'm literally just using excel for the reporting aspect.

thanks

[ranman256]

that is the problem with crosstabs, they keep changing, so difficult to report.
you could make a 'report' table. It has 14 weeks as:
name, col1, col2, col3...etc..col14, StartDate

append the data to the tRptTbl.
the report on this table could use vb to alter the report labels using the StartDate column, then add 1 date until all 13 labels are changed to the new daterange.

[DoleseII]

Thanks, that's what I was afraid of. Now, I have some rework to do. (10) hrs into the project lol)

I appreciate the feedback.