[AccessD] Blank Lines On Report

Neal and Gustav:

That worked! A union query joining the query from the original report and a
table of blank lines, then another query taking the top 35 from the union
query, which fills one page.

Thank you.

Rocky

----- Original Message -----
From: "Gustav Brock" <gustav at cactus.dk>
To: "Rocky Smolin - Beach Access Software" <accessd at databaseadvisors.com>
Sent: Thursday, February 20, 2003 8:16 AM
Subject: Re: [AccessD] Blank Lines On Report


> Hi Rocky
>
> You could make a union query where you select the records as now and X
> number of similar empty records from a dummy table. X is the maximum
> amount of records that one page can hold.
>
> Then feed this query to another where you Select Top X ..
> Use this as source for your report.
>
> /gustav
>
> > I need to put some blank lines at the end of a report to fill up the
page.  The report is a list of patients for a doctor on rounds with a couple
of other fields to fill in.  The fields have solid,
> > visible borders and make a lovely grid.  I can get the number of records
in the report so I know how many additional lines I need to fill out the
page.
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>