I have a list box that has years (ListYears) in it and it is used to sort the years on the report based on selection.
Currently if you want four years of data on the report, the user has to select 1, 2 , 3 and 4 on the list box to get that data.
I want to create the row source of the list box so that ; 1 = 0 and 1; 10 = 0 to 10, etc.
Should i create an U Bound array expression on the ListYears row source or should I type it in SQL view?
Currently if you want four years of data on the report, the user has to select 1, 2 , 3 and 4 on the list box to get that data.
I want to create the row source of the list box so that ; 1 = 0 and 1; 10 = 0 to 10, etc.
Should i create an U Bound array expression on the ListYears row source or should I type it in SQL view?