How to format the result of a calculated control

  • Thread starter Thread starter Abay
  • Start date Start date
A

Abay

In my report I want to total a field called Deposit_amt, so following the
instructions from Access help, I created a calculated control with the
expression

=Sum([Deposit_amt])

This works fine, but how do I format the resulting 5105, which should look
like 5,105.00 .. when I click on properties on the control the only
formatting available is for dates ... my first time , obviously using
calculated controls .. that's my only excuse .. learning as I go along

any help would be much appreciated.


ebay
 
In my report I want to total a field called Deposit_amt, so following the
instructions from Access help, I created a calculated control with the
expression

=Sum([Deposit_amt])

This works fine, but how do I format the resulting 5105, which should look
like 5,105.00 .. when I click on properties on the control the only
formatting available is for dates ... my first time , obviously using
calculated controls .. that's my only excuse .. learning as I go along

any help would be much appreciated.

ebay
Click to expand...

=Format(Sum([Deposit_amt]),"#,###.00")
 
Back
Top