Adding total to running total

[cwbviper]

Hi there,

I have created a database which will record number of days absent. However i want to keep a running total of this, so our Company Administrator enters the number of days absent in a field, this will enter the number into an additional field, and keep a running total when more entries are made in the first field.

Any help is much appreciated.

Cheers

Colin

 

[grande]

Private Sub FirstField_AfterUpdate
    Me.SecondField.Value = Me.SecondField.Value + Me.FirstField.Value
End Sub

Like that?

-------------------------
Just call me Captain Awesome.

 

[cwbviper]

Hi Grande,

That is exactly the kind of thing i was looking for.

Many thanks.

Cheers

Colin