View Full Version : Multiple Entries one a Single Page of a Report


bpowers
01-24-2009, 11:29 AM
Hi,

I have a database with about 10 different fields each containing information about a specific date. For this specific database it is important to have a clean report that can be generated. I have been fiddling around with the design view and have it about where I'd like it but with one, kind of big, problem. Since I dont have that many fields two entries can easily fit on one page. However Access seems to be set so that each entry gets its on page. I tried to fix this by adding another layout on the bottom half of the page. However, instead of drawing from the next entry - the frist page contains two sets of identical reports of the same entry. I have looked through all the properties and done a ton of searcing online and havent figured out how to fix this. I feel like there must be some way to instruct the field to draw from the next entry but I cant seem to figure it out. Any help would be appreciated

Pat Hartman
01-24-2009, 01:14 PM
ALL controls in the Detail section draw from a single record so adding additional controls for the same fields will simply duplicate information as you have seen. You should be able to control the number of records that print on a page by adjusting the height of the detail section. Your question seems to indicate that you have the force new page property set to yes for the detail section. You need to change that to no.