Hello,
On my report in Microsoft Access for all fields I have set-up this code in Control source:
=Replace(Replace(Replace(Format(Sum([NameOfTheField]),"#,###.00"),".",""),",","."),"",",")
and on this way I managed to replace format "123,456.78" to "123.456,78" because I need to have Euro formatting on report.
This code works ok but problem is when some column contains zero value, then I would like to replace "0" with "-" and I don't know how to achieve this?
And help is appreciated and many thanks for prompt replys!
Cheers