Cumulative Update field in table

[bluenose76]

i am trying to get a table to automaticaly calculate numbers entered into a field, for example field 3 allready has the number 10 inside it, if i then enter the number 15 i want the field to calculate the existing number with the new number and display 25?

currently when i update the field then i will see 15, so i need to tell it to do something else and that is where i am stuck!

please help.

Bev

 

[The_Doc_Man]

Through a form? Directly in a table? Through a query? Some other method?

Give us just a smidge of context. Just a SMIDGE.

 

[bluenose76]

the truth is i am not sure of the best way to go with this one?

for example in my table i will have two fields that say:

field 1 = Bev field 2 = 25

if i am using a form to update this, the intention is that the form will show the two fields with Bev populated and the number blank, i want to then type the addition in e.g. 10 and then when you select enter or click out of that field for the table to then show 35

this way when i print a report it will show 35 and not 25

 

[bluenose76]

thanx,

I will try that and will be back if i get stuck again