How to jump records

[aashish_9601]

i have designed an two column report.
in the first column i want to print the first 10 records (i.e from 1-10) and in the second column i want to print the second next 10 records (i.e from 21-30). So that on the back side of the page i can print the records from 11-20 in the first column and from 31-40 in the second column.


After printing i will be tearing the paper into two equal parts.

[anhn]

That seems to be impossible, unless you sort recordset in order as what you want. You may jump forward but cannot jump backward.

[wes4dbt]

I think you would have to manually load the report recordset thru coding logic, that is, create a new empty recordset then use a second recordset for retrieving the records from the table. Depending on how you setup the table, create coding logic that would load the report recordset in the proper order. If you find a SQL that will do it using only one recordset please post it.

Good Luck