Format a number as text in query

M

Matt

Without changing the format in the table? What exactly are you trying to
accomplish with this? I'm not sure I follow...
 
J

JeffH

I have a Employer Number in the table stored at a number. I'm importing it
into an Excel application which has it stored as a text field. Since Excel
has it as text field and it imports as a number all my Lookups don't work.
Accordingly, I would like to "fix" the format of the Access data right away
in the query I use to import the Employer Number.

I know how to change it in Excel, I would rather change it upon the initial
import since I will be handing this off to a less experienced user and I
don't want to bothert them with changing formats.

Accordingly, I would like to change the number to text upon import of the
queried information into Excel.
 
M

Matt

Is there a problem with changing the format of the cell in the entire table?
Or do you need it stored as a number in your database, then as text in a
query? If the prior is true, just go to design view in the particular table
and change the Data Type to Text.
 
Top