Thread: Stacked Ticket Numbering

I have perforated ticket stock which has 10 blanks per page. I want each page to contain 10 numbered tickets but to have the tickets "stacked" so theare printed in the order shown below: That way when they are torn apart they will be 'stacked' in correct numerical sequencer. I want to be able to have the form ask for the number of sheets to print and then the number of tickets per sheet (in case I have stock which has a different number of perforated tickets) and then generate a query (or report) that will have the numbers in the correct sequence. I will use the result as a merge file for an InDesign ticket template.
FIRST SHEET
"1"
"11"
"21"
"31"
"41"
"51"
"61"
"71"
"81"
"91"
SECOND SHEET
"2"
"12"
"22"
"32"
"42"
"52"
"62"
"72"
"82"
"92"
THIRD SHEET
"3"
"13"
"23"
"33"
"43"
"53"
"63"
"73"
"83"
"93"
FOURTH SHEET
"4"
14"
"24"
"34"
"44"
"54"
"64"
"74"
"84"
"94"
and so on.......