Easy Multiple Select Parameter 1

[checkai]

I have completely forgotten how to write the Record Selection when using parameters that you can select multiple values...or Select All...I have a list that containing officename/officeID and an added record called '** ALL **' with description = -1...i'm assuming it's obvious what I want to do from here...just cant remember if they select multiple offices how to put that in...thanks.

 

[vidru]

'** ALL **' with description = -1

I'm assuming you have that backwards(?), as in value of -1 and Description of '** ALL **'.

If your ID fields are Numbers, then this should work:

If Not (-1 In {?MultiParam}) Then
{Table.Field} In {?MultiParam}
Else If -1 In {?MultiParam} Then
True

-dave