I want to display range of alphabets between two alphabets selected in list boxes
example : I have two listboxes From and To , If I select 'A' in From listbox and 'E' in To listbox then result should display ABCDE in table
I do not want to concatenate the selected values in range , I want to show the data in report between selected alphabets range
example data in report should show between values 'A' to 'E'
another solution using alternate states, set expressions and sample data from your thread listbox from and to date might be:
Money(Rand()*100) as sales
hope this helps
will it work for alphanumeric values?
If user enter From value '13l1A' and To value '14D1A ' in the input box and then click on button then below mentioned values should be selected as green in below Listbox
Values should selected as green:
Your initial question was how to reduce a table based on selections in two list boxes.
Selecting field values based on inputs in input boxes is another question.