format numbers

[Guest]

Some of my aggregate calculations in my queries can't be formatted. The
format box in the properties is blank. How do I format the result of an
aggregate calculation?

 

[Marshall Barton]

Some of my aggregate calculations in my queries can't be formatted. The
format box in the properties is blank. How do I format the result of an
aggregate calculation?

Somehow or other, it probably got converted to type Text.

You didn't say where you want to use the formatted value,
but in most cases, you can explicitly convert it to the
correct numeric data type so formatting will be working with
something it understands. E.g. CCur(totalamountdue)