From: Hirsutus on 6 Mar 2010 18:33 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 7 Mar 2010 11:01 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
|
Pages: 1 Prev: Access 2007 - Date Serial Next: how to run onhand value report |