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 bkrike 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
- Thread starter TJVFree
- Start date
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
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.
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.
SkipVought
Programmer
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?
Good call Andy. This is one of those questions that should be accompanied by some context and examples.
Duane
Hook'D on Access
MS Access MVP
Duane
Hook'D on Access
MS Access MVP
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question