Importing data from ODBC data source

[ebiscaro]

HI All,

I am importing in access and excel various bits and pieces of a SQL database. The issue here is that all data stored in the SQL are in
S.I. and I need to perform unit changes.

I have linked the table I am interested with in acess and I am performing various query. I would need to change units to make the data usable
when I am opening the query. At the moment I am bringing the data in with a make table query. On the new table I perform an update query to change the units. This involves 2 passages that I have a macro perfor. My question is: Is there a way to perform the conversion using only one passage?

Thank you in adavnce

Enrico

 

[Pat Hartman]

I'm not sure what S.I. is so I can't help with the calculation. However, you don't actually need to create a table to store the converted values, you can convert them in a query and use the query as the recordsource for your forms or reports.

Select fld1, fld2, (fld3 / .5) As ConvFld3 From YourTable;

 

[ebiscaro]

received tks

Thanks I will try that.