Conversions when Linking to an External Table

  • Thread starter Thread starter mcl
  • Start date Start date
M

mcl

OK, I'm dealing with weather data here. I've been linking to external tables
in oracle using ODBC.
For example the temperatures in oracle are celcius * 10. So 10.5C would be
105 (TempC10 is field name). Is it possible when linking to do the
conversion on the fly (rather that using a query later) and having the table
in the linked table display the temp in F, ie. TempC10*.18+32?
 
You should probably create a view on the server and link to that instead.
Otherwise, you're stuck using a query within Access to do the conversions.
 
Back
Top