how do I add 2 amounts in a form using Access

[klhering]

I have created a form using a table and then using a query as a subform. What
I need to do is have a text box that will display "Total Payments"in the main
part of my form, in my subform I have the payments made, which are listed in
rows. but I can not figure out a formula that will give me the sum of the
payments. I put in the text box and have tried a few different expressions in
the expression builder but nothing is working.

Any ideas??

 

[Jeff L]

Try using DSum. Look it up in help.

 

[Klatuu]

Have a look at the orders form and subform in the Northwind database. It
does exactly that.