Coding question to sum all records 1

[eon5]

I have created a form with the following information;


Key field1 field2
Records ID: Expense1: Expense2:
001 R20 R25
002 R15 R10

Of course the form is displaying only one record at a time with the values of Expense1 and Expense2 in it. In the one corner of the form I have created a text box displaying the sum of the two expenses.

“ = [Expense1] +[Expense2] = R45 “

All of this is working perfectly, but how do I code another text box on the same form displaying the total value for expense 1 and 2 for all the records entered thus far. In other words the text box should read R70.

Thanks
Eon5

 

[macropod]

Hi Eon5,

What application? If Word, are these textbox formfields?

Cheers

[MS MVP - Word]

 

[eon5]

It is an Access application
Thanks

 

[PHV]

You may use the DSum function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[eon5]

Thanks for the advice, i will give it a go

eon5

 

[eon5]

Thanks PHV, it workds perfectly

eon5