Convert Numbers to Text
Convert Numbers to Text
(OP)
Can someone please help me? I need to convert a numbers column in an access table to a text format
TCB
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS Contact USThanks. We have received your request and will respond promptly. Come Join Us!Are you a
Computer / IT professional? Join Tek-Tips Forums!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines |
|
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
Register now while it's still free!
Already a member? Close this window and log in.
RE: Convert Numbers to Text
You can use CStr([YourNumericField]) or in a query just add a zero-length string [YourNumericField] & "".
Duane
Hook'D on Access
MS Access MVP
RE: Convert Numbers to Text
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.
RE: Convert Numbers to Text
RE: Convert Numbers to Text
Duane
Hook'D on Access
MS Access MVP