D
dfredriksson
I have data coming from different sources. I would like to control the
formats when either using a Make Table query or an Append query. In some
sources, a column might be a number data type in another source it might be a
text data type.
I want to be able to convert all the data from the different sources to a
text data type.
Is there a way to convert data type from one table to another using a
formula in a query?
Thanks
Dana
formats when either using a Make Table query or an Append query. In some
sources, a column might be a number data type in another source it might be a
text data type.
I want to be able to convert all the data from the different sources to a
text data type.
Is there a way to convert data type from one table to another using a
formula in a query?
Thanks
Dana