Prev: Access 2007 - Date Serial
Next: how to run onhand value report
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