Printable View
Hello, I have a report pulling data from access. The data is put in the detail field. Is it possible to get more than one record of data on one detail line at a time? I have an 8.5x11 sheet of paper with labels on it...and would like to fill each label...not just down the left side of the sheet.
The DataReport is pretty limited and printing multiple records in a section is not supported.
What you need to do is create a recordset that contains the same fields X number of times. For example, if you have 3 labels per row the recordset fields could be
Address1, City1, State1, Address2, City2, State2, Address3, City3, State3
I don't know the sql statement to generate such a recordset. I would use an in-memory recordset and populate it manually. The in-memory recordset would be the data source for the report.