Range Based Parameter

[PMRiley]

I am trying to amend a report to allow for an age range to be selected, so have set up a numeric parameter {?Age} and set the default range to be 20 to 30.

My problem is that when the person's age is 30 there is other criteria needed checking that is irrelevant to anyone aged 20-29.

How do I cheek the data entered in this parameter to check if the user has included 30 in the age range?

(Due to the nature of this report, the age range specified will never be outside of the 20-30 range and it is just the 30yr olds that need additional checks)

CR10 on SQL DB

 

[PMRiley]

Please feel free to ignore - a fresh cup of coffee has just made me spot my stupidity!!!

 

[lbass]

As a matter of practice, you should always share your solution, so the thread can be helpful to other readers.

-LB