Filtering with a drop-down list - one or "all"

[coldspring]

I am trying to set up a portal filter where the user can select a particular value out of a drop-down list or choose "All". If they choose "All" I want the filter to return the related records for every value in the drop down.

For example -

Drop-Down List values - 107, 108, 109, 110, 111, 112, All

I might choose 107 in which case it would return only those records with 107.

I might choose All in which case it would return those records with 107, 108, 109, 110, 111 and 112.

Thanks in advance for the help on this.

[comment]

Create a calc field (result Text) =

Valuefield & "