Changing Data Format

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
 
C

Chris2

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.
 
Top