Changing Format of Access Field via Query?

[assron]

HI all,
Here is what i have, two Oracle tables across multiple schemas that I
cannot change the actual format in the table.
One table has the field = Text
The other table has the field = Number/Decimal/10 Precision

I need to link these two together to run some data and currently I
have been making a temp table
and changing the TEXT one to a NUMBER but am wondering if there is a
way to change the Format of the TEXT one to a Number in a query which
would save me from having to always be making a TEMP TABLE.

Thanks in advance for any help you can give..

Aaron

 

[Arvin Meyer [MVP]]

Try using an aliased column like:

Expr1: CDbl([YourTextField])

Then link the Expr1 Column to your number column in a second query.