Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Print empty rows

    I have a report which is a staff rota. At the moment, I have it set to print 20 rows per sheet. What I would like it to do is, if there aren't enough records to fill a sheet, print empty rows, so extra staff could be written by hand. So if there are 25 staff, 5 would print off on the second page, and there would be 15 rows of blanks. Can this be done easily?
    Last edited by robm; 2014-02-08 at 10:00.

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Silver Lounger mrjimphelps's Avatar
    Join Date
    Dec 2009
    Location
    USA
    Posts
    2,158
    Thanks
    204
    Thanked 209 Times in 201 Posts
    I assume you are speaking of Excel.

    If you don't mind handling it manually, it's very easy. Select the entire area that you want to print, including the blank rows at the bottom. Then choose Page Layout / Print Area / Set Print Area.

    Excel will now print the area that you selected.

  4. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts
    No, I'm talking about an Access report.

  5. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,497
    Thanks
    3
    Thanked 42 Times in 42 Posts
    One way would be to make the data source of the report a UNION query with a table that contains 15 empty records that look like the recordset of the existing query, and add a sort field so you force the blank records to be at the end of the report.
    Wendell

  6. #5
    2 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    162
    Thanks
    0
    Thanked 24 Times in 24 Posts
    Here is trick I use for this.

    How to Print a Constant Number of Lines Per Group
    This article describes how to create a constant number of lines per data group on a report. You can use this method to consistently print 15 lines per data group, regardless of the actual number of items within the group.
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •