Please Help

[rakaisa]

Hi,
I need help with the following table:
item A contains items 1,2,3...


item B contains items 1,2,3...
-------
-------
item N contains items 1,2,3...

and,
item 1 :a b c subtotal(1)
item2 :e f g subtotal(2)
.......
.......
item n: x y z subtotal(n)


the problem is to make a form where I have a field1 for the list down of item A,B.... and a field2 to find the grand total i.e total of all subtotals based on the chosen item from the list down

please help me
thank you

[Rainlover]

Why do you store the same data many times????

[rakaisa]

Hi,
its actually different values
i should have written as
A1 :
[T1 a1 b1 c1 a1b1c1 x d1=(a1b1c1x)
T2 a2 b2 c2 a2b2c2 y d2=(a2b2c2y)
T3 a3 b3 c3 a3b3c3 z d3=(a3b3c3z)
--
--
--
Tn an bn cn anbncn i dn=(anbncni)]
TA1= d1+d2+d3+....dn


B1 : same as above but different values
etc.

list down box should contain A1,B1 etc
and the next column should provide me with the TA1 or TB1 or whatever corresponding value based on chosen value in the list box

thank you

[Rainlover]

I am sorry

But why the C n D approach.

Please post something that makes sense in real English terms.

I need to be able to understand what you are doing in order to help.

I have never been good at algebra so please post real names.