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!

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

Can a number be changed to words? 1

Status
Not open for further replies.
bosk00

bosk00

Technical User
Mar 5, 2004
91
0
0
US
I have a situatin where we are trying to use information from a data base. One of the fields we have is a quarterly fee. I am trying to automate the printing of contracts. In the database the fee would be "345". But on the contact it need to be printed as "Three Hundred Forty Five Dollars ($345.00)". Does anyone know of a way to do this?

Thanks in advance

Alan
Senility at its finest
 
Sort by date Sort by votes
Thank You Leslie, This is the type of thing I was looking for.

Alan
Senility at its finest
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
297
serino
serino
btamsgn
  • Locked
  • Question
how to create a crosstab query 1
Replies
1
Views
170
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Can not get Access 2016 queries to accept form value input or TempVars! input 2
2
Replies
21
Views
209
TheresAlwaysAWay
TheresAlwaysAWay
accesshelp1
  • Locked
  • Question
How can I remove parenthesis and everything that comes after it? 1
Replies
3
Views
147
Andrzejek
Andrzejek
btamsgn
  • Locked
  • Question
How to arrange the values in column heading based on column STT
Replies
10
Views
320
combo
combo

Part and Inventory Search

Sponsor

Back
Top