Parameter Query - Sinlge parameter multiple values

steve-waters · Newbie Joined: 06 Jan 2008 Posts: 2

Hi,

I am just trying to put together a simple app that will run a report based on a parameter query that can take a list of values.

e.g. select loans
where loannumber in [123,1231,124,432,34,235,235,25]

(above is not the sql being used ust to give you idea)

I have been able to make a query that has a parameter for loan number and accepts a single value, but i have not been able to work out how to input many values and then return the results.

Thanks,
Steve

Sliderule · Posted: Sun Jan 06, 2008 7:21 pm Post subject:

Steve:

The answer . . . assuming you are using the Query GUI ( Graphical User Interface ) is rather simple . . . BUT . . . it does NOT include using an IN clause.

In the example below . . . I defined a Query . . . and the user is prompted to enter a maximum of six ( arbitrary number for example purposes only ) entries. You can expand this to whatever meets your needs. Each prompt is 'defined' by using the OR capability.

Since, the ORDER that the prompts are displayed is 'alphabetical' . . . and . . . it canNOT begin with a number and must be one word . . . I elected to start each with a :Q followed by an underscore followed by a number ( 01 to 06 ) followed by an underscore followed by a description, change this to meet your needs.

The user may 'fill-in' the prompt(s) for as many as desired . . . and . . . press the Next button to enter the next Parameter. When as many as desired are entered . . . pressing the OK button is needed. I hope the graphic below will clear things up for this simple example.

Please note, if you were to produce this same query with SQL . . . it would look like:

steve-waters · Newbie Joined: 06 Jan 2008 Posts: 2

Thanks for the reply. Close but no cigar Smile

The solution is close to what I was seeking and a good tip to have in my armoury however it is not what I need to happen for this report/query.

The query is to be setup so user can enter a varying number of items, 1 -> n. Which is why I was hoping to be able to pass a list to the query rather than have individually named items.

Thanks,
Steve

Sliderule · Posted: Mon Jan 07, 2008 4:04 pm Post subject:

Steve:

You said: