Parameter List

[RexesOperator]

Somewhere within the deep recesses of my brain, I recall seeing a method of creating a parameter list. I have tried a number of sources, but have come up empty - probably not searching on the right words.

Right now I have a parameter prompt "Enter FILE NUMBER".

I want to be able to enter more than one number and the numbers won't necessarily be contiguous.

An example would be "Enter FILE NUMBER(S):"

The answer might be "10859, 10100, 10903". I've tried using a comma and a semi-colon to separate the list members, but I know I have to make a change in the original query.

What do I change?

 

[Jon K]

You can use the InStr() function in the criteria.

Switch the query to SQL View and change the Where Clause to the following (using the correct name of the file number field):

SELECT ..........
FROM ...........
WHERE InStr("," & Replace([Enter FILE NUMBER(S):], " ", "") & ",", "," & [FileNumberField] & ",")


The Replace() function removes the spaces in your given data for comparison by the InStr() function .
.