Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. Brief overview of Running Queries in Voyager Prepackaged Access Reports

    Brief overview of Running Queries in Voyager Prepackaged Access Reports

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Product: Voyager
    • Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare

     

    Question

    Overview of running queries in Voyager Prepackaged Access Reports.

    Answer

    To run a query double-click on it, or right-click on the query and select "Open".

    While it is running you will see:

    Hour glass cursor.

    Run button in the ribbon colored.

    "Running query" displays.

    For long-running queries, sometimes Access will provide the first screenfull of results but it isn't done.  You need to click on the last record tool at the bottom of the screen.

    clipboard_ee7c388efa09085921ae118dbb47bc388.png

    NOTE that if the column headers display but with nothing below them, that means the query is done but there were no data to be returned!

    clipboard_e435e13edc7c5a39cda9e15d35a3c7bc5.png

    Sometimes queries get hung and you need to close Access.  In that situation, restart Access using the .MDB and not the .LDB file.

    Additional Information

    See also:

    Brief Overview of Reading Queries in Voyager Prepackaged Access Reports

    Brief overview of Tables in Voyager Prepackaged Access Reports

    Brief overview of Running Queries in Voyager Prepackaged Access Reports

    Brief overview of Query Views in Voyager Prepackaged Access Reports

    Brief overview of making simple changes to queries in Voyager Prepackaged Access Reports

     

    Constructing custom SQL queries by request and troubleshooting unexpected results from customer-created SQL queries falls outside the scope of Support. The above has been posted for informational purposes.  Voyager-L and Developer Network are useful resources for finding helpful custom SQL or obtaining assistance from peers in troubleshooting custom queries.

     


    • Article last edited: 11-Mar-2021
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Brief overview of record relationships in Voyager cataloging
      • Brief overview of string functions in Voyager Prepackaged Access Reports
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved