Using Between with Prompt Values

[navshiv]

I have a prompt in a report to select a range of suppliers. The filter says to display suppliers between prompt 1 and prompt 2. When I enter a and z (converting to upper) it displays all suppliers apart from those beginning with z.

When I say between z and zz it does display the supplier beginning with z.

Any ideas how I can get all suppliers to show up?

 

[iguanadon]

You already figured out the little nuance with using "between" by using ZZ as your end range. I would simply use ZZ or ZZZ to ensure capturing all vendors unless you have Sleeping Beauty as a supplier and her company name is Zzzzzzzzzzz.

 

[sonksen]

In the ASCII table, the character { comes after z.
So, if the prompt 2 is set to {, all names beginning with a letter will be returned.