query looping

[kkson]

How do you loop through a query?

I have a report that can take 12 records per page. so the first 12 get a level of 0. then the next 12 get a level of 1 and so on.

if i delete one of the 12 in a given level (it may be in the level 0 or another level) and there is another level behind it (ie level 0 has 11, and level 1 has 1. so on the report it would print 11 on page one and 1 on page two.)

I can't figure out how to get the qry to go through and renumber the records incrimenting after 12 to the next level up.

Thanks for the help

 

[PHV]

Why not assigning the level in the report instead ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kkson]

the levels are acually column headings and across and down is not an option. so assigning the levels before hand is required. there could be more than 12 column headings also so i need the level to separate the pages.