Hi Eric,

 

Thank you for the link(s).

 

I don’t think this is what I’m specifically looking for as your link seems to apply to procedures and variables.

 

What I’m looking for is to create parameters that can be used in filters. Ok, yes they can be used in filters now, but when I’m creating a parameter I have to enter a default value, and then this default value will be automatically used in the filters too.

 

Say I have a parameter called, Fruits, and the default value is ‘Apples’.  When I run create my report this parameter is added to the filters and I link it to the database field ‘fruits’.  This report will now by default run for ‘Apples’.  But sometimes I want this report to run for all fruits, not just ‘Apples’ or whatever else I put into the parameter.

 

The reason why I’m using a parameter is because I have 5 fields that could contain the same value and instead of doing a user prompt for 5 fields, I want the user to enter a value one time (using the parameter) and then the 5 filters could be linked to the one parameter field.

 

Angelo