I am trying to create a query based on a date range, that will display multiple currencies and re-label a column header.

when range is constructed you need to use Col reference in your query