View Single Post
  #2 (permalink)  
Old January 4th, 2006, 08:48 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I think it you have four text boxes with calculated values, you can sum them by referring to the text boxes, and not to the record field, like:

=Sum([txtField1]+[txtField2]+[txtField3]+[txtField4])

I use this technique for other purposes and it seems to work.

HTH

mmcdonal
Reply With Quote