Calculated field in form in a Table

[Mike Dove]

I don't know if this is the correct group, but I could not find one more
suitable.

I am attempting to create a calculated field in a form, I have bookmarked
fields for On The Road Price, Less Allowance and Cash Deposit. The Cash
Deposit and the Less Allowance a simple addition called Total Deposit. The
field I am having difficulty with is Credit field, this is the On The Road
price less Total Deposit, The result I am getting is printed below. All
fields are ticked for calculate on exit

Total On The Road Price £
5000.00

Less Allowance £
1000.00

Plus Cash £
1000.00

Total Deposit £
2000.00 Calculated Field

Amount of Credit £
-19997000.00 Calculated Field







Any suggestions to cure this problem would be most welcome

Mike

 

[Suzanne S. Barnhill]

See "WD2000: Calculation in Form Field Shows Wrong Result" at
http://support.microsoft.com/?kbid=211253

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Mike Dove]

Just got the thing working by usesing cell reference rather than attemptin
gto be clever and use bookmarks.

Mike