concatenate text field and money field

[biskra]

i use this code for concatenate 2 fields in my report

CODE

=[name] & " - " & [price1]

it works fine, my only problem is i can't see the symbol money in my texte boxe on my report like "book - 500.00$"
any help.
sorry for my bad english

 

[zoria8]

Hi!

You could have it hard coded in:

=[name] & " - " & [price1] & "$"

Or you could format it specifically:

=[name] & " - " & format([price1], $#,###.00)

Hope that helps!

 

[biskra]

ok i use this

=[condamnation] & " " & FormatCurrency([ammande])

 

[biskra]

sorry

=[name] & " " & FormatCurrency([price1])

 

[Rich]

=[name] & " - " & Format([price1],Currency)