Can you help me on how to create queries with dynamic field. Meaning field to be displayed may be either coming from text box value...... combo box value... etc.

Example: I have a table with the following field

department year Week1total Week2Total Week3total ............Wee knTotal

Now the query should create the field department, year and the WeekTotal
where the weektotal will be coming from...