Discussion Locked

how to show sum of subform

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In Access 2000, I design a form with a subform, for example, A is made up of B, C, D, .......
B, C, D, all have their own weight.
How can I show total weight of B, C, D, ....... in the main form?

2 replies

by eschlangen

One way would be to link a control to a query that sums the weights that show up in the subform. For example, if the subform is linked to the master via a field named LINK and the weights are in field WEIGHT, write a query like "SELECT SUM(WEIGHT) FROM WHERE LINK = me.LINK". You could substitute the entire form identifier for "me" but "me" should work.

This discussion is closed to new replies.