[AccessD] Blank Lines On Report

Well that's who I actually solved it - with two queries - union and then one
taking the top 35 from the union.  Just trying to gild the lily here, I
guess.  But I gotta try your solution.  Looks promising.

Rocky

----- Original Message -----
From: "David McAfee" <DMcAfee at haascnc.com>
To: <accessd at databaseadvisors.com>
Cc: "'Rocky Smolin - Beach Access Software'" <bchacc at san.rr.com>
Sent: Thursday, February 20, 2003 3:23 PM
Subject: RE: [AccessD] Blank Lines On Report


> 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
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com