How to display both non-entry classes and Confirmed to Show entries in reports

Article ID: 113032
Category: Reporting
Date Added: 7/26/2014
Date Updated: 8/25/2021


Some users wish to create or view reports (such as the Judging Sheets) that not only display classes that do not have any entries under them, but also restrict to display only entries that have been marked "Confirmed to Show". Turning on the feature "Include non-entry classes in judging sheets" under the Tools>Options>Reports menu will display the non-entry classes, but if one chooses to filter the report for entries "Confirmed to Show", those non-entry classes will no longer be included. Such an "either or" condition exists and some users wish to have both.


The following steps require the user to have the appropriate version of Microsoft Access installed on their machine which will allow the user to use the "ShoWorks Access Companion" icon. Please note that we do not provide technical assistance for Microsoft Access as this is out of the scope of our support. For more information about this feature, please see the following article: How to edit reports using Microsoft Access with the ShoWorks Companion


  1. Exit ShoWorks
  2. Open the ShoWorks Access Companion
  3. Press the F11 key and enter the passcode "companion"
  4. Right-click on the query named "y_Entries including classes with no entry" (located in the list of objects on the left, under the gray group "Queries - System") and select Design View
  5. In the first column "Entry Number", insert two lines in the criteria: Is Not Null on the first line, and Is Null on the second line.
  6. Scroll to the right to find the column "Confirmed to Show" and insert a Criteria that reads True on the first line.
  7. Close and save changes

Please note that these steps will need to be repeated if an update to ShoWorks or reinstall is ever performed on the machine.

Question not answered in this article?
Click to Contact GladStone support for more information.

Login here with your
Service Plan Number

Need help in locating your Service Plan Number?