I have a field in which my boss wants two separate parameter prompts on the same field (I have always used a range parameter).
The two prompts would be 1.) |enter first number| and 2.) |enter last number|
The field is just a number (it can only be 2 through 5).
If |enter first number| = 2 then |enter last number| would give a choice of 2, 3, 4, or 5. If they enter 5 for|enter last number|then you would get values 2, 3, 4, and 5 in the report. If they enter 3 for |enter last number| then they would get values 2 and 3 in the report.
However, if |enter first number| = 3 then |enter last number| could be 3-5
If |enter first number| = 4 then |enter last number| could be 4-5
If |enter first number| = 5 then |enter last number| could only be 5
I'd also like a dropdown option and an ALL in the dropdown for both parameters which would just return all results.
If this is possible at all I would really appreciate the help. I'm pretty new to this but I bet this would be pretty tricky.