Currency Format

[tacieslik]

How can i make the following result display the a pound (£) symbol and to 2 decimal places:

="Total Unpaid for" & [fldMonth] & "  " & Sum([fldProfit])

This textbox currently displays in my report as " Total Unpaid for July 191.123 "
(without quotes!)

 

[maxmangion]

you should make the field set to currency and set the amount of decimal places from the properties window

 

[tacieslik]

Thanks for your reply but the first thing I tried was to adjust the property for the data format and the decimal places in the Properties dialog?

 

[tacieslik]

Actually, I've got it putting a £ sign in simply by doing this:

="Total Unpaid for" & [fldMonth] & "  " & "£" & Sum([fldProfit])

The problem is the decimal places?

 

[maxmangion]

since you contain text as well in your textbox, you cannot set it to currency:

="Total Unpaid for" & [fldMonth] & " " & Sum([fldProfit])

why don't you place the pound sign between the quotes ?

="Total Unpaid for" & [fldMonth] & " £ " & Sum([fldProfit])

and then in the properties dialog of [fldProfit] set the decimal places to 2.

Not sure if it is the best approach but it should get you going!

 

[Rich]

="Total Unpaid for" & [fldMonth] & " " & Format(Sum([fldProfit]),"Currency")

 

[tacieslik]

Thanks Rich, works a treat