Query Set-up with special column headings

[anotherlevel]

I have about 10 columns with data in each column...the columns dont need to show every time. I want to set it up where the user pics the column heading from a drop-down menu and then that column alone will show, none of the other columns are visible...can this be done?

 

[grnzbra]

I don't know if there's an "official" way to do it, but you could declare
a variable as a query def, set the query def equal to the name of the query, set a string equal to the sql statement of the query selecting just the desired field and then set the querydef.sql equal to that string.