format numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...


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)
 
Back
Top