Array Required? (1 Viewer)

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?

What about a multi select list box?


Sent from my SM-G925F using Tapatalk

Sorry I have omitted to mention that it is a multi select list box but the user has said that it would be easier to use the values in the multi select list box to designate an array or values instead of only 1 or 10.