By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,571 Members | 960 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,571 IT Pros & Developers. It's quick & easy.

Changing Format of Access Field via Query?

P: n/a
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..

May 23 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.