From: Hirsutus on
I am trying to calculate the total quantity of components in a nested Bill Of
Materials where the true quantity of any sub-level component is dependant on
the quantity of the previous higher component.

Level Item number Quantity
1 A123 1
2 A124 2
3 A125 2
3 A127 1
2 A126 1
2 A125 1
1 A128 1
2 A130 2

From: KenSheridan via AccessMonster.com on
Take a look at:

http://community.netscape.com/n/pfx/forum.aspx?tsn=1&nav=messages&webtag=ws-msdevapps&tid=23133


The file is attached to the second post in the thread.

Ken Sheridan
Stafford, England

Hirsutus wrote:
>I am trying to calculate the total quantity of components in a nested Bill Of
>Materials where the true quantity of any sub-level component is dependant on
>the quantity of the previous higher component.
>
>Level Item number Quantity
>1 A123 1
>2 A124 2
>3 A125 2
>3 A127 1
>2 A126 1
>2 A125 1
>1 A128 1
>2 A130 2

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201003/1