How to convert from Currency to text.

FISHiEE

Fish obsessive
Local time
Today, 06:00
Joined
Nov 12, 2004
Messages
86
I am sure it must be very simple but I can't find the command!

I need to convert a currency value to a text value for use in a combined string, say £123.00, to the text string "£123.00".

Basically I want one of the reports to say "£123.00 each less x% discount".

Currently I am using :

[Door Price] & " each less " & [Discount] & "% discount"

which will display "123 each less x% discount"

I could add the £ sign in code but if I add the .00 as well I will then have problems with a price of say £123.50!

Surely there must be a simple command that does this for me?

Cheers!

John
 
Code:
Format([Discount], "£0.00")
 
Perfect!

Cheers!
 

Users who are viewing this thread

Back
Top Bottom