|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 6th, 2010, 11:33 PM
posted to microsoft.public.access.queries
|
|||
|
|||
How do I access multiple records within a query?
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 
|
|
#2
March 7th, 2010, 04:01 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
How do I access multiple records within a query?
Take a look at:
http://community.netscape.com/n/pfx/...apps&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/For...eries/201003/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
