Log in

View Full Version : Database


paulfish64
Dec 13, 2002, 04:20 PM
In a database I have inputed a subform. The subform adds up totals of plants by adding Price*quantity. That is fine, the problem I have is that I want to have a box that adds up all the plants totals to give an overal price. Anyway you can help me?
Thanks

ScottGem
Jan 23, 2003, 10:33 AM
It would help if you indicated what database you were working in. I'm going to assume you are using Access because of your mention of subforms.

This technique is illustrated in the Northwinds sample so you might look there.

What you do is put a footer on your subform. In the footer put an unbound textbox and make the Data source the formula: =Sum([Price]*[Quantity]). You can then reference that text box on your main form if you wish.