Change Field name in table/query based on another table in access

Hello.
I have an access DB (I know no VBA but can copy and paste) In it I have a query with field names I need changed before I spit out a report.

For example:

Query1 (could be made into a table if that helps)
Item
Description
1
2
3
4

Table:
Wk#
Date

In the above table it always is numbered in WK# column starting with 1, 2, 3, etc but date for 1, 2, 3 etc will be a different date each week. The table is create earlier in the DB based on data feed to it.

I need to take the final query (Query1) and change the field names from 1 to whatever date is in the table for 1, 2 to whatever date is in 2, etc.

Any ideas? I understand queries, intermediate macros but very little VBA (just starting to learn)