How do users specify what they need?
If they enter a start week and you always want a fixed
number of weeks after that week, then change the query to
pivot on the relative week number:
"W" & (WeekNum - [start week])
which will be columns like W0, W1, W2, ...
The fields will then always have the same names.
To get the column headings back to what you had before, use
text boxes (instead of labels) with expressions like:
="week no" & ([start week] + 0)
="week no" & ([start week] + 1)
="week no" & ([start week] + 2)
. . .
MVP [MS Access]