Results 1 to 2 of 2
  1. #1
    dcraw12 is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2014
    Posts
    1

    force a report with zero entries


    not a programmer, just a novice user. I have developed a simple program to keep track of exhibitors and classes entered for a county fair. I print out a report with a list of exhibitors entered in each class on separate pages. If there are not entries in a particular class, it doesn't print. How can I force access to print a blank report page for every class even if it has no entries? Thanks.

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Depends on your structure.

    If you have a table for classes, table for exhibitors, and a junction table containing the foreign key to both classes and exhibitors it would be pretty simple.

    You'd just create a query based on your CLASSES table then link it to your junction table, and finally from the junction table to your exhibitors table, make sure the arrow linking the tables is pointing FROM classes TO your junction table and FROM your junction table TO your exhibitors table. Then you should get a row that is blank except for the CLASSID/NAME which you can show in the page header with nothing under it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to force Page Footer to the bottom of report
    By nightangel73 in forum Reports
    Replies: 1
    Last Post: 06-20-2014, 11:46 AM
  2. Replies: 1
    Last Post: 09-25-2013, 10:33 PM
  3. Limit entries on a report
    By Derrick T. Davidson in forum Reports
    Replies: 3
    Last Post: 03-17-2013, 09:33 PM
  4. Force New Line in columned Report
    By gg80 in forum Reports
    Replies: 7
    Last Post: 09-20-2012, 07:00 PM
  5. Replies: 3
    Last Post: 11-13-2011, 10:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums