Multiple parameters 1

[CJSilver]

I have a form that has a click button and two combos, this form is used to select the parameters needed for a query. With the way it is now, I have to select both parameters otherwise my query opens without any data. What I want to happen is, the user can select either parameter.

I have one parameter that is employee name, the other parameter is team. I want the user to be able to either just select their name OR select a team, but they don't have to select both.

C. Johnson

http://www.SilveradoCable.com

 

[PHV]

SELECT ...
WHERE ([employee name field] = [Forms]![form name]![employee name comboname] OR [Forms]![form name]![employee name comboname] Is Null)
AND ([team field] = [Forms]![form name]![team comboname] OR [Forms]![form name]![team comboname] Is Null);

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[CJSilver]

Thanks again PHV!

I appreciate your help!

C. Johnson

http://www.SilveradoCable.com