how do I add 2 amounts in a form using Access

G

Guest

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??
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

numerical summation to passed from sub to main form 2
Access Main and subform subtraction and balance 1
Calculating a text box 9
Reducing Balance on Invoice 9
Reporting in main form total of subform field (in continuous forms 5
text box update problem 6
Order of Events for Sum? 2
Very slow textbox expression 3

Top