Re: Help! Keep getting duplicate page

Tech-Archive recommends: Fix windows errors by optimizing your registry

"Mark Jackson" wrote

When I preview my report I get 11 pages of
the same thing. How do I setup my report so
it is one page? I have the page setup in my
report is set to Letter in Landscape mode with
margins for Top, Bottom, Left, and Right set to
0.166. The column size is set to 10.2083" width
and 6.7083" Height. I don't understand how
to set the report so it has only one page.

Try running the Query that is the RecordSource of the Report to make sure
there is only one page worth of data. If more, then it's the Query that's
the problem, not the Report. As we can't see your report, you need to
clarify what you have -- are you saying that you have eleven pages of
identical data? If you were thinking that Access has a "fit to page"
option, like some other software, that is not the case. Post a follow-up
response to this to let us know about the data produced by running the Query
directly, and details of what you have, what you see, and what you expect.

Larry Linson
Microsoft Access MVP


.

Relevant Pages

  • RE: Transpose data in a report-Field values broken down to separat
    ... Microsoft Access MVP ... "Duane Hookom" wrote: ... Then create a main report based on only the unique values of ID and Name. ... a query, along with my response, that explains the need further: ...
    (microsoft.public.access.reports)
  • RE: Sorting in Query and Report involving look up combo box
    ... Dave Hargis, Microsoft Access MVP ... query and the report and the best way to do that is having the look up field. ... I have the report grouped by Artist Name and then Sorted by Style Number ...
    (microsoft.public.access.reports)
  • RE: Sorting in Query and Report involving look up combo box
    ... Dave Hargis, Microsoft Access MVP ... "Esaw" wrote: ... I have the report grouped by Artist Name and then Sorted by Style Number ... the output of the query based on the field or fields in the ORDER BY ...
    (microsoft.public.access.reports)
  • RE: Mutliply reports all at once
    ... button to run the report. ... Dave Hargis, Microsoft Access MVP ... "The Uke" wrote: ... Now when you run the query, you will see a column with the name PrintReport ...
    (microsoft.public.access.reports)
  • RE: Sorting in Query and Report involving look up combo box
    ... Dave Hargis, Microsoft Access MVP ... "Esaw" wrote: ... query and the report and the best way to do that is having the look up field. ... I have the report grouped by Artist Name and then Sorted by Style Number ...
    (microsoft.public.access.reports)