[AccessD] Blank Lines On Report

David McAfee DMcAfee at haascnc.com
Thu Feb 20 17:15:00 CST 2003


Wouldn't it be something like:

SELECT TOP 35 *
FROM
(SELECT * FROM qryPostingSheetReport 
 UNION ALL 
 SELECT * FROM tblBlanks)
 
I confuse myself bouncing back between SQL and Access.
A simple way to do it is create just the UNION query, save it. 
Create a new query selecting the TOP35 from the UNION query, then look at
the SQL statement that Access creates for you ;)


HTH
David McAfee
-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Rocky Smolin - Beach
Access Software
Sent: Thursday, February 20, 2003 2:29 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Blank Lines On Report


No.  Top 35 from both - the union.

Rocky

----- Original Message ----- 
From: Susan Harkins 
To: accessd at databaseadvisors.com 
Sent: Thursday, February 20, 2003 2:08 PM
Subject: Re: [AccessD] Blank Lines On Report


Top 35 from each? Good question Rocky, I'm assuming the syntax would be the
same as any other, but I've never tried it.

SELECT TOP 35 * 
FROM qryPostingSheetReport 
UNION ALL 
SELECT TOP 35 * FROM tblBlanks

Just gave it a short test and it worked for me. 

Susan H. 



----- Original Message ----- 
From: Rocky Smolin - Beach Access Software 
To: accessd at databaseadvisors.com 
Sent: Thursday, February 20, 2003 3:07 PM
Subject: Re: [AccessD] Blank Lines On Report


SQL Susan:

Where in this Union Query would I put the TOP predicate if I just wanted the
Top 35 records?

SELECT * FROM qryPostingSheetReport UNION ALL Select * FROM tblBlanks;

TIA,

Rocky

----- Original Message ----- 
From: Susan Harkins 
To: accessd at databaseadvisors.com 
Sent: Thursday, February 20, 2003 9:29 AM
Subject: Re: [AccessD] Blank Lines On Report


By set format, I just meant you knew how many lines would be on each page,
each time. If it's just a question of "filling in" to a set point, the page
break may work for you -- it's on the Toolbox. Just position it next to the
left margin and it will force the report to start printing on the next page.
Positioned in the right spot, it should work if all you're doing is "filling
in" -- the report would add lines until it hits the page break. 

Susan H. 
----- Original Message ----- 
From: Rocky Smolin - Beach Access Software 
To: accessd at databaseadvisors.com 
Sent: Thursday, February 20, 2003 11:36 AM
Subject: Re: [AccessD] Blank Lines On Report


Susan:

What do you mean by 'set format'?  The number of records will vary.  But the
fields in the detail section are fixed.  How can I use Page Break. I need to
add a certain number of blank lines in boxes.

Rocky

----- Original Message ----- 
From: Susan Harkins 
To: accessd at databaseadvisors.com 
Sent: Thursday, February 20, 2003 8:16 AM
Subject: Re: [AccessD] Blank Lines On Report


Rocky, if the report's a set format, the Page Break control is the easiest
way. Just position it where you want it. If the format varies, that's a
different story. :) 

Susan H. 

 
Dear List:

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.  

Is there an easy way to do this?

TIA

Rocky Smolin
Beach Access Software



More information about the AccessD mailing list