Query with repeating frequencies

[marko]

Hello!

I have a query that returns:

Name Freq.
John 10
Mark 10
Matthew 15
Luke 20

If my total number of pieces is, say, 100, then I need a query that will return values as in my example below using values in column frequency to fill out space between 1 through 100.

Piece Name
1 John
Mark
Matthew
Luke

10 John
Mark

15 Matthew

20 John
Mark
Luke

30 John
Mark
Matthew
.
.
.
.

90 John
Mark
Matthew

100 John
Mark
Luke

Thank you!

Marko

 

[chenn]

Not sure what you want to do. Is the # of pieces a separate field? If so, just sort the field. That will return:

10 John
10 Mark

20 Joe
20 Bob ...

 

[marko]

Hi!

I had to generate those records. Anyway, I figured it out but thank you on your response.

Marko