Format within a string

[wdrspens]

I am sure this is the easiest problem to answer and has probably been answered many times before, but I have a string in a report that is:



="A 25% booking deposit of " & Sum([calcTotal])/4 & " is due within 14 days"

How do I format the & Sum([calcTotal])/4 so that it gives a currency result complete with the currency sign. I believe I can use 'round' to get two decimal places, but can I use something else to give 2 decimal places and the appropriate currency sign?

I can achieve the result by using the following:

="A 25% booking deposit of £" & Round(Sum([calcTotal])/4,2) & " is due within 14 days"

But if the figure is a whole number it does not give the answer to two decimal places which means it looks untidy since all other fields are to two decimal places.


Many thanks

David

[wdrspens]

I think the answer is Format(Sum([calcTotal])/4,currency) anyway I'll give it a try in the morning.

It did not work, but the answer appears to be Format(Sum([calcTotal])/4,"#,###.##"). That is working at the moment.