unbound sum textbox

[samer]

Hi,
I am trying to make calculations in an unbound textbox, those
Calculated number will be coming from a field formatted as a
Standard number and 2 decimals digits …
What’s happening is: in the unbound textbox I am getting results
Like this:
10.20 + 10.40 = 20.00
but I would like it to appear like this
10.20 + 10.40 = 20.60

 

[doran_doran]

Format...

Is your 3rd Text Field where you calculating A+B set to correct format. I mean Format should be Fixed and decimal should be 2.

Good Luck
Dianna Goldsberg

 

[samer]

Is your 3rd Text Field where you calculating A+B set to correct format. I mean Format should be Fixed and decimal should be 2.

Good Luck
Dianna Goldsberg

format should be fixed and dicimal should be 2 ,yes it shull be . but when
opening properties you will not find dicimal option ... the textbox will be :
=sum([the field]) ...
thanks for replying .

 

[R6Flyer]

Samer

Are the 2 numbers to be totalled stored in a table?

If so, check that the field size is set to single as opposed to long integer. The attached database should demonstrate what I mean (A97 format).

 

[samer]

Samer

Are the 2 numbers to be totalled stored in a table?

If so, check that the field size is set to single as opposed to long integer. The attached database should demonstrate what I mean (A97 format).

Thanks a lot ,
best regards .