Display column by user selected name?

[mostuniquename]

Here is my problem. I have a table with a lot of columns. I want the user to be able to select which column he wants to display in a query/report, how do I do that? Is there some kind of way to do a command

SELECT

.[like [user input]]

either in SQL or Query Design, so that a form would pop up and ask user for input, and then display column whose name corresponds to that input.

 

[pbaldy]

In a word, no. You'd have to build the query dynamically in VBA. You'd also have to do something dynamic in the report, since field names would be changing.

The columns don't represent repeating data, like January, February, etc, do they?

 

[mostuniquename]

that sucks

Columns represent names, rows are dates, it's an attendance database.

 

[pbaldy]

It doesn't really suck; what you've got there is a spreadsheet trying to disguise itself as a database. Proper design would be a record for each date/name combination. With proper design, you'll have no problem extracting data.