 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / November 2006How to print A5 vouchers on an A4 sheet from an access database
>Hi all > >I want to print 1,000 A5 vouchers on an A4 sheet from an access database- >Name, Address, Postcode, etc (only one of each record) maintaining postcode order as to deliver by hand. >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 unique reference number 501 - 1000 > >Is this at all possible please, thanks Garry Garry, Am I reading this right?... Is getting the 1-500/500-1000 split here the main issue? If so, you could make a calculated field in the query that the voucher report is based on, like this... FirstSort: ([Reference Number]-1) Mod 500 ... and then sort descending on this field in your report, followed by a secondary sort on the actual reference number field. (assuming Reference Number is a number data type). I think this will produce the results you want... first page will print with records 500 and 1000, next page will print with records 499 and 999, etc, last page to print will be records 1 and 501.  SignatureSteve Schapel, Microsoft Access MVP >> Hi all >> [quoted text clipped - 8 lines] >> >> Is this at all possible please, thanks Garry Steve, I might not of explained very well, let's have another go ! Say 3 records have a ref no of 333, 2 have 444 1 have 555 If I just print two vouchers per A4 sheet I get ( sorted ascending by ref no ) 333 / 333, then 333 / 444, then 444 / 555 Cut in half and placed one stack underneath the other I get 333,333,444,333,444,555 (know out of sequence) The required sequence is 333,333,333,444,444,555 Thanks for your time, Garry > Garry, > [quoted text clipped - 21 lines] >>> >>> Is this at all possible please, thanks Garry |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.