[AccessD] Blank Lines On Report

Ah... hmmmmm.... I imagine you'll have to requery or go with a subquery on that one Rocky. 

SELECT TOP 35  *  FROM 
(SELECT *
FROM source
UNION ALL
SELECT *
FROM source
ORDER BY field)

Problem is, you're going to end up with the top 35 of the first source -- I think Rocky. Try adding an Order By clause if necessary. 

SUsan H. 


  ----- Original Message ----- 
  From: Rocky Smolin - Beach Access Software 
  To: accessd at databaseadvisors.com 
  Sent: Thursday, February 20, 2003 5:28 PM
  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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030220/2230b6ce/attachment-0002.html>