ACCESS FEED: Re: [MS_AccessPros] Columns in a report

Minggu, 19 Oktober 2014

Re: [MS_AccessPros] Columns in a report

Thank Duane, too!

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Oct 19, 2014, at 7:34 AM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Thanks John,

That works well.

Thanks again,

Robin

At 19/10/2014 01:37 PM, you wrote:

Robin,

The number of rows per page depends on the height of the detail section, height of group and page headers and footers, margins, as well as paper size. Do the math for instance:

11" paper size

1/2" top margin

1/2" bottom margin

10" detail section (2" X 5 rows)

0" (no page or report sections)

===================

11"

Duane Hookom, MVP

MS Access
________________________________
> Date: Sun, 19 Oct 2014 10:58:01 +1100
>
> Thanks John,
>
> I tries twice and failed to find an option to limit the page to five rows.
>
> Regards,
>
> Robin
>
> At 18/10/2014 06:17 PM, you wrote:
> Robin-
>
> It sounds like you want a Label layout - 4 across and 5 down. Try using
> the Report Label wizard.
>
> John Viescas, Author
>
> On Oct 18, 2014, at 7:23 AM, Robin Chapple robinski@westnet.com.au
>
> I am using Access 2013. I am attempting to make a report with four columns.
>
> The report is a single field intended to be 20 records per sheet.
>
> How do I limit the report to print five lines of data per page?
>
> Many thanks,
> Robin Chapple