 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / April 2008Identifying copies
When printing a report with multiple copies, is there anything like a "CopyNumber" property that could be used to identify the individual copies? I suppose the alternative is to have a Label or TextBox and paste the description in there. Many thanks Peter Kinsman One possible solution is to create a copies table like: tblCopies =============== CopyNum CopyTitle 1 Store 2 Customer 3 Another One Then add this table to the report's record source and don't join it. Add the fields to the query grid and set the criteria under the CopyNum field to something like <=2 to get two copies. Set the primary sorting and grouping level in the report to CopyNum starting a new page following the CopyNum footer. This solution creates a number of duplicates.  SignatureDuane Hookom Microsoft Access MVP > When printing a report with multiple copies, is there anything like a > "CopyNumber" property that could be used to identify the individual copies? [quoted text clipped - 4 lines] > > Peter Kinsman The use of a Cartesian product is most elegant - especially as I think it could be expanded by adding a "ReportName" field with criteria, so that the one table could control the distribution of all reports. Many thanks Peter > One possible solution is to create a copies table like: > [quoted text clipped - 26 lines] >> >> Peter Kinsman Because the report has a page count, Ia little more work was required. 1) [Pages] is the total number of pages in all of the copies, so I have printed the page count as [Pages] / Dmax("PageNum", "tblCopies") 2) [Page] needs to be reset for subsequent copies, so I have set it to 1 in the OnFormat event of the PageNum Header. Having reread it, I think this is the same as the online help suggests. It seems to work anyway, which is always the main test. Peter 1) could be overcome by printing .. " of " & [Pages] / Dmax("PageNum", "tblCopies") but I cannot > The use of a Cartesian product is most elegant - especially as I think it > could be expanded by adding a "ReportName" field with criteria, so that [quoted text clipped - 35 lines] >>> >>> Peter Kinsman |
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.