[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/3da56f26/attachment-0002.html>