Multiple Parameter Query

[broygus]

Background:
I have a database that tracks indexes monthly over a long period time. I have a query that builds based on query parameters of date and which index they are looking to find. The output would then show me for that given index what the returns were over set periods of time.

Problem:
I'm trying to have the query ask for multiple parameters (by saying that I mean I want it to ask for Multiple indices entered) so that the final output would list more then just one index...and I'm not looking for it to output every index that I keep data for, just the ones indicated)

-thanks

 

[IFELSETHEN]

Hi .... If I hear you correctly you can do this with sub-selects. Something like this:

Select (Select statement for Index 1) as number1, (Select statement for Index 2) as number1, Etc.....
FROM .....

HTH,
Regards John

*********************
John Nyhart

http://www.nyhart.com

*********************