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

Try using an aliased column like:

Expr1: CDbl([YourTextField])

Then link the Expr1 Column to your number column in a second query.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>