Sum problem

  • Thread starter Thread starter Ryan Tisserand
  • Start date Start date
R

Ryan Tisserand

I have a form [TMHP] with a subform [TMHP subform]. In the subform I have a
unbound textbox named [TotalAllow] that sums a control named [Alow] with a
simple =Sum([Allow]). This is a currency field and for some reason there is
never any change. What I mean is, if the answer should be $100.50, it will
show $100.00 I have made shure the decimal is set to auto, I even changed
the decimal to 2 and 4 and got the same results. The underlying query is
showing the correct value, but for some reason on the form it will not show
the change. Any suggestions.
 
I did. The field is a number field, with 9 precision, 2 scale, and decimal
set to auto.

NetworkTrade said:
make sure field is defined as currency and that scale is defined as 2
--
NTC


Ryan Tisserand said:
I have a form [TMHP] with a subform [TMHP subform]. In the subform I have a
unbound textbox named [TotalAllow] that sums a control named [Alow] with a
simple =Sum([Allow]). This is a currency field and for some reason there is
never any change. What I mean is, if the answer should be $100.50, it will
show $100.00 I have made shure the decimal is set to auto, I even changed
the decimal to 2 and 4 and got the same results. The underlying query is
showing the correct value, but for some reason on the form it will not show
the change. Any suggestions.
Click to expand...
Click to expand...
 
Back
Top