>>>I have a form that presents a grid which is based
>>>on a view. The View has 3 selection criteria, department, location and status which are variables
>>>macroed in. The form gives users combo boxes to change
>>>values for each criteria and the grid requeries. It works fine. I Want however to allow the user to select
>>>ALL for any or all of the criteria but I cant figure
>>>how to do this since the selection in the query builder
>>>expects 1 specific value for each.
>>>
>>>Any Ideas?
>>>Chris
>>
>>Instead of one equal to criteria parameter use two greater-equal and less-equal parameters. In a case when you need one value supply two identical GE and LT parameters. When you want to get all values make your filter as wide as possible!
>
>inlist might help you as well...
Inlist is fine if we have to pass few values not all. Probably, you meant BETWEEN !?
Edward Pikman
Independent Consultant