How do I change Text to a number format

  • Thread starter Thread starter PerryK
  • Start date Start date
P

PerryK

I have a crosstab query that is uses a table that is formated as TXT.
(It comes from a server this way, so I have no control over the original
format)

I would like to change the format to a Number instead of text.

This is the in SQL view:

TRANSFORM Max([RM MIS From L01A Rpts].OGM_CALLS_PCT_PLAN) AS
MaxOfOGM_CALLS_PCT_PLAN
SELECT [RM MIS From L01A Rpts].ORG_GROUP_ID AS Dist
FROM [RM MIS From L01A Rpts]
WHERE ((([RM MIS From L01A Rpts].DISPLAY_HEADER) Not Like "2008*"))
GROUP BY [RM MIS From L01A Rpts].ORG_GROUP_ID
PIVOT [RM MIS From L01A Rpts].DISPLAY_HEADER

Any suggestions would be appreciated.
 
Perry

Use a query.

Create a new query in design view. Add the table you have.

Add the fields you want to show in your crosstab.

For those fields that you require as numbers, 'coerce' them, using something
like (untested):

NewField: CInt([YourOldField])

to coerce into Integer, or use CCur() to coerce into decimal with four
places (calling it "currency" is a misnomer).

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
.... sorry, one more thing.

After you have the new query done, "point" your crosstab query at THAT new
query, instead of at the table.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Back
Top