D
David
Hi,
I have a query against an SQL data table column, which is defined as "user
defined" text. These are fields the software vendor allows us to use for our
purposes, and can define as text, numeric, etc.
I want to convert this field to Number, Decimal, Precision 10, 0 decimal
places, in a query, as I want to use this field in a subsequent query to link
to a key field in another table, which is defined as Number, Decimal,
Precision 10, 0 decimal places.
The current issue I have when linking these two fields (User Defined and Key
Field) is the message: "Type Mismatch In Expression".
Thanks in advance.
I have a query against an SQL data table column, which is defined as "user
defined" text. These are fields the software vendor allows us to use for our
purposes, and can define as text, numeric, etc.
I want to convert this field to Number, Decimal, Precision 10, 0 decimal
places, in a query, as I want to use this field in a subsequent query to link
to a key field in another table, which is defined as Number, Decimal,
Precision 10, 0 decimal places.
The current issue I have when linking these two fields (User Defined and Key
Field) is the message: "Type Mismatch In Expression".
Thanks in advance.