Jim Lawrence
accessd at shaw.ca
Sat Jul 7 11:01:37 CDT 2007
Hi Rocky: These columns are fixed length. The wrinkle to the design requirements is that there are 3 individual sections within the report and the data source is in one table and it looks like as follows: Ref#, Client-Name, Account-Detail, Date, Payment The data is sorted so it group appropriately; Date, Client-Name etc. Programming within the report determines which section it is and how it will be printed. The following is a text imitation of the report and how it will print: MY REPORT --------- Line 1: Section A: Acquired Line 2: Ref#, Client-Name, Account-Detail, Date, Payment ... Line 11: Section B: Prospect Line 12: Account-Detail, Date, Payment Line 13: Account-Detail, Date, Payment ... Line 25: Section C: Referral Line 26: Ref#, Client-Name Line 27: Ref#, Client-Name Line 28: Ref#, Client-Name Line 29: Ref#, Client-Name Line 30: Ref#, Client-Name Line 31: Ref#, Client-Name ... Section C could go on for pages but would be more compact if it looked like: Line 26: Ref#, Client-Name, Ref#, Client-Name, Ref#, Client-Name Line 27: Ref#, Client-Name, Ref#, Client-Name, Ref#, Client-Name ... The Report would have to be able to something as follows. Within program control the report would have to pause while continuing to step through the data, accumulating the records in an array and when 3 records were gathered or the end of that section was reached, it would release the pause, print out and continue... I am sure it is doable... Any suggestions would be greatly appreciated. TIA Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of rockysmolin at bchacc.com Sent: Saturday, July 07, 2007 6:28 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Access Reports rinting accross Are the records fixed length or variable? For variable, I'd use a temp table with one record, and concatenate the original records into temp table records, using a fixed width font. Then bind the report to the temp table. I suppose you could do the same for fixed length records as well. HTH Rocky Original Message: ----------------- From: Jim Lawrence accessd at shaw.ca Date: Sat, 07 Jul 2007 00:53:17 -0700 To: accessd at databaseadvisors.com Subject: [AccessD] Access Reports rinting accross Hi All: Is there a way to print across the page within an Access report? Like in the following example: Record01 record02 record03 record4 record5 Record06 record07 record08 record9 record10 record11 record12 record13 record14 record15 record16 record17 record18 record19 record20 etc......... MTIA Jim -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------------------------------------------------------------- myhosting.com - Premium MicrosoftR WindowsR and Linux web and application hosting - http://link.myhosting.com/myhosting -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com