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