[AccessD] Blank Lines On Report

Hey!  It worked!

Rocky

----- Original Message -----
From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
To: <accessd at databaseadvisors.com>
Sent: Thursday, February 20, 2003 5:39 PM
Subject: Re: [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
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com