Question about Field names

[Pathfinder]

Hi

I have a question for you... what if I have a table with different
field names as example Field1,Field2,Field3,Field4 and Field5.
I want to make only one query where I can run it and based on the user
request I need to show for example Field1,Field2 from the table. The
second run of the query, the use change his input and runs Field1,
Field3...so the query had to adapt to the user input and display
Field1 and Filed3 and sooo on.
The idea is instead of making for every possible input a query...I
need to make one query which can display the result based on the user
selection of Field names.

thanks for your help

[John Winterbottom]

"Pathfinder" <pa*************@yahoo.com> wrote in message
news:ce**************************@posting.google.c om...

Hi

I have a question for you... what if I have a table with different
field names as example Field1,Field2,Field3,Field4 and Field5.
I want to make only one query where I can run it and based on the user
request I need to show for example Field1,Field2 from the table. The
second run of the query, the use change his input and runs Field1,
Field3...so the query had to adapt to the user input and display
Field1 and Filed3 and sooo on.
The idea is instead of making for every possible input a query...I
need to make one query which can display the result based on the user
selection of Field names.

maybe something like this:

parameters [col1] int, [col2] int;
select switch
(
[col1]=1, Field1,
[col1]=2, Field2,
[col1]=3, Field3,
[col1]=4, Field4
) as FirstColumn,
(
[col2]=1, Field1,
[col3]=2, Field2,
[col4]=3, Field3,
[col5]=4, Field4
) as SecondColumn
from foo