print 1,000 A5 vouchers two too view on an A4 sheet

[Garry]

Hi all

I want to print 1,000 A5 vouchers (only one of each record) two too view on
an A4 sheet.

When I guillotine the A4 in half and place the right stack underneath the
left
stack they will remain in order i.e. left stack unique reference number 1 -
500,
right stack 501 - 1000

Is this at all possible please, thanks Garry

 

[John Vinson]

Hi all

I want to print 1,000 A5 vouchers (only one of each record) two too view on
an A4 sheet.

When I guillotine the A4 in half and place the right stack underneath the
left
stack they will remain in order i.e. left stack unique reference number 1 -
500,
right stack 501 - 1000

Is this at all possible please, thanks Garry

Does this question have anything whatsoever to do with Microsoft
Access, the Office Pro database software?

If so please describe your database structure, and probably repost in
the Reports newsgroup.

If you're using Word or Publisher, please repost in a newsgroup for
that program.

John W. Vinson[MVP]

 

[John Spencer]

In a report you could sort by a formula and the reference number

First sort order
= ([RefNo]-1) Mod 500 +1
Second sort Order
= [RefNo]

That should put the records in the order
1, 501, 2, 502, 3, 503, ...499,999,500,1000

Use the report's sorting and grouping. If you wanted you could use the
query to calculate the value to be used in the first sort order.