Multiple Pages based on # of Records

  • Thread starter Thread starter Rob G
  • Start date Start date
R

Rob G

I have a database that I created to keep track of data
entry when reviewing an insurance claim file. When I
create a report I get multiple pages and it seems to be
proportionate to the number of records that have been
entered into the database. I figured it was a margin
problem but it is not and I cannot seem to get it down to
1 or 2 pages depending on the length of the report. If it
matters any I am using Dcount in the body of my report to
get stats on the data entered.

Rob G
 
There are a couple of things you can check. Open your
report in design view. Check to see if you have any group
headers or footers. If you do, check to see whether they
have page breaks specified in their properties. It sounds
like you don't want these.

The other thing you can look for - in the detail section,
you will see all your fields. If there is alot of white
space under your fields, this is going to show up as blank
lines on your report. Click on the bottom of the detail
section and pull it up to the bottom of your fields. This
will eliminate blank lines after details.

Hope this helps.
 
I figured it out. Queries property tab - hit Top Values
to 1, and it solved my problems. Thanks
 
Back
Top