Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert Numbers to Text

Status
Not open for further replies.

TJVFree

Technical User
Nov 22, 2010
236
0
0
US
Can someone please help me? I need to convert a numbers column in an access table to a text format

TCB
 
Your question is a bit spartan. I assume you have a need to only format the value and not change the data type of the field.
You can use CStr([YourNumericField]) or in a query just add a zero-length string [YourNumericField] & "".

Duane
Hook'D on Access
MS Access MVP
 
TJVFree may want to do this (who knows…?)

1 convert to “one”
10 convert to “ten”
123 convert to “one hundred twenty three”



Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.
 
Do you want to change the data IN THE ACCESS DATA COLUMN to text in the Access Table, or do you want to convert the numeric values from you Access data column to text in a query?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top