access error "type mismatch in expression"

[Guest]

I have a linked table. The table is linked to an oracle database.

I have a query I'd like to join to the linked table. The field I'd like to
join to the linked is a calculated field.

The field is calculated, because the oracle field I'm querying on contains
numbers and text. I'm parsing out the numbers into a separate field and
trying to link that field to another table.

Problem is I keep getting an error message saying "Type Mismatch in
Expression". The data type of the table field is "number", whereas I'm
unsure how to determin the data type of the calculated field in the query
table.

I'd appreciate any suggestions anyone may have.

 

[John Vinson]

I have a linked table. The table is linked to an oracle database.

I have a query I'd like to join to the linked table. The field I'd like to
join to the linked is a calculated field.

The field is calculated, because the oracle field I'm querying on contains
numbers and text. I'm parsing out the numbers into a separate field and
trying to link that field to another table.

Problem is I keep getting an error message saying "Type Mismatch in
Expression". The data type of the table field is "number", whereas I'm
unsure how to determin the data type of the calculated field in the query
table.

Try using one of the conversion functions to explicitly cast the
value. For instance, if the table field is a (default) Long Integer
number, make the calculation expression in CLng( <expression> ) to
convert whatever value comes out into a long.

John W. Vinson[MVP]