Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / April 2008

Tip: Looking for answers? Try searching our database.

Format a number as text in query

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JeffH - 28 Apr 2008 16:35 GMT
Is there a way to format a number as text in my query?
Matt - 28 Apr 2008 16:53 GMT
Without changing the format in the table?  What exactly are you trying to
accomplish with this?  I'm not sure I follow...
Signature

-Matt

"The only thing worse than an employee that just quits and leaves, is an
employee that quits and doesn''t leave."

> Is there a way to format a number as text in my query?
JeffH - 28 Apr 2008 17:13 GMT
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.

> Without changing the format in the table?  What exactly are you trying to
> accomplish with this?  I'm not sure I follow...
>
> > Is there a way to format a number as text in my query?
Matt - 29 Apr 2008 15:25 GMT
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.
Signature

-Matt

"The only thing worse than an employee that just quits and leaves, is an
employee that quits and doesn''t leave."

> 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
[quoted text clipped - 13 lines]
> >
> > > Is there a way to format a number as text in my query?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.