Don't know if that is possible or not but as an alternate solution..
you can create a button named Select Month and add an action
Select In Field
Now once you select any Month and click on that button.
It will select all previous + your selected months.
Hope this helps.
I did something similar to Manish's reply. I created an input box which would select all the numbers less than and equal to the input value. If user inputs 5 then 1 to 5 would be selected in the list box.
Another suggestion: You can use set analysis in this balance calculation such that it will include all months <= selected month instead of selecting all months in the list box.
Test1.qvw 148.2 K
you might also create a selector table, which contains a selector field (e.g. MonthSelector) that links to all months less or equal the MonthSelector value.
Ceil(RecNo()/10) as Month,
Round(Rand()*100) as Data
LOAD Month as MonthSelector Resident tabData;
LOAD Month Resident tabData;
Where Month <= MonthSelector;
DROP Table tabTemp;