Subtotals in forms

[Guest]

Hi all,

I have the following problem which I can not figure out. I have a database
in which I have products which are also assigned to product groups. What I
would like to do is to create a form in which I could have all products
listed and at the end of each group a subtotal. e.g.:

Product Value
A ....
B ....
C ....
Total products group A sum of A,B,C

D ....
E ....
F ....
Total products group B sum of D,E,F

I know this can be done in a report, however I have to amend the values and
show the impact on the total of the product group.

Could anyone please help.

TIA

 

[Guest]

There is no graceful way to do this. First, it would have to be either a
continuous form or a subform with a datasheet. Neither has these grouping
capabilities. One posibility would be to have a form with a subform for each
group, but then, you don't know how many groups you might have, and controls
on forms are not that dynamic. You might consider some sort of drill down
methodology where you show just the group name, number, and total for that
group, then let the user select a group and then open the detail on that
group.

That is the way I would go about it.

 

[Guest]

Ok, thanks Klatuu.
Prevents me to go mad, searching for the solution!