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. Receive the "Type mismatch in expression" error when running a query in Voyager Prepackaged Access Reports

    Receive the "Type mismatch in expression" error when running a query in Voyager Prepackaged Access Reports

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

     

    Question

    I am trying to create a custom query and receive a "Type mismatch in expression" error.

    Answer

    The “Type mismatch in expression” message comes up occasionally when you try to create a new Access query or run a query that you have just changed. It means that the fields that you use in one of your links connecting your tables are of different types. In other words, one field is a number and the other is a text string.

    Most fields that look like numbers are treated by Access as if they were text strings. But there are a few exceptions, which are treated as numbers, and these are the ones that trigger the “Type mismatch” error message.

    This error can also occur when importing data into Access using an Excel file and incorrectly setting the Data Type.

    For more information about data types, see the Voyager Data Dictionaries and ER Diagrams.

    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: 18-Jan-2021
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Receive "You are not authorized to receive this item for any location" when doing check-in or check history of serial in Voyager Acquisitions
      • Received Partial on PO when nothing received?
    • 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