Range of value [from] - [to]

[Z.Cochrane]

Hello,

I have a Report which looks like this

Employee A
Bill 1
Position 2
Position 3
Position 4
Position 5
Position 9
Bill 2
Position 7
Position 16
Position 17
Position 18

 

[Duane Hookom]

You could remove the positions from the main report and put them in a
multiplecolumn subreport. Another method is to concatenate the positions
together into a single, comma delimited string as displayed in the function
at http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Neither of these methods will group consecutive values like your desired
display. However, I can't imagine having positions numbered like your
example.