Problem w/ multiple values parameter in record selection

[bkrampe]

Hi everyone and thanks in advance.

I am using CR XI and Access 2003.

I have a database with information put in by job number(ex:227488, 227495, etc.) I am needing a report that allows the user to put in multiple numbers and it will only pull in those jobs. I am trying to use the Allow Multiple Values option but so far have been unsuccessful.

I am guessing i am over thinking this one.

 

[Turkbear]

Hi,
In what way have you been unsuccessful in using the Allow Multiple Values option?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[bkrampe]

What formula would you put into record selection to pull in the data. I have tried a couple. Seems like any formula i use either gives me a "A number range is required here" or just does not pull in any data.

 

[lbass]

If job number is of number datatype, then your parameter must be set up as a number parameter also. Or if it is a string, then the parameter must also be a string. Then allow discrete values and/or ranges and allow multiple values. Your record selection formula would be the same:

{table.jobno} = {?JobNo}

..regardless of whether there are single or multiple values or ranges.

-LB

 

[bkrampe]

Oh man. :O I'm sorry everyone i forgot to change the parameter to a number field. Changed that and everything worked wonderfully.

Told you it was probably something simple. I am so thankful its Friday.

Thanks everyone. Sorry again.