Change expression in Access

[keilah]

Hi

How can i change the following expression

Month 0: ([0]*[size]) which gives me the result of number in the following format 2883.2453

to

?2,883.25.... (all numbers to 2 demical place and in this format)


thanks, feedback appreicated still learning..............

[Tommy]

You can use the format statement. Not sure if you can use it in the expression builder though.
Format(SomeNumber,"?#,###.00")

[matthewspatrick]

keilah,

You can use Format() in query expressions, but honestly I would instead suggest that you use the number formatting in your form/report controls to handle this. Using Format() changes your number to text, so that constrains your ability to use the result in calculations.