Changing Data Format

  • Thread starter Thread starter E. Ehrhard
  • Start date Start date
E

E. Ehrhard

I am bringing over data via ODBC linked table. One of the
fields is linked to several other tables that I have. The
issue is the linked table's data is formated as number and
all of the other data sources are text. Is there a way
through a query possibly to change format of the data?

Thanks

E
 
E. Ehrhard said:
I am bringing over data via ODBC linked table. One of the
fields is linked to several other tables that I have. The
issue is the linked table's data is formated as number and
all of the other data sources are text. Is there a way
through a query possibly to change format of the data?

Thanks

E
Click to expand...


SELECT CStr(L1.NumberField)
FROM LinkedTable AS L1

The output of this query will be text-type data.
 
Back
Top