Using a textbox for a column name

[Myriad_Rocker]

How in the world can I accomplish this? I have a set of dates on a form that change from week to week. I'd like to reference these text boxes in a query as column names. How can I do this?

 

[Myriad_Rocker]

I got to thinking about it a bit and couldn't I actually do something like this?

First, define my column variables as text and then store the text fields into those variables. Then...

SQL = "SELECT ColName1 As " & ColVar1 & ", ColName2 As " & ColVar2 & " etc...