Sum problem

[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.

 

[NetworkTrade]

make sure field is defined as currency and that scale is defined as 2

 

[Ryan Tisserand]

I did. The field is a number field, with 9 precision, 2 scale, and decimal
set to auto.

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

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.