[AccessD] Blank Lines On Report

Gustav Brock gustav at cactus.dk
Thu Feb 20 10:17:49 CST 2003


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.  




More information about the AccessD mailing list