By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,639 Members | 2,276 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,639 IT Pros & Developers. It's quick & easy.

multiple level Bill of material Explosion - need help

P: n/a
Hi Guys
I'm a novice access VBA programmer. Iím trying to write a nested query
to explode the bill of material. But the BOM table has more than 20
levels. Itís really redundant and annoying to write all those nested
queries in access. my question is, how do I approach this problem to
solve it using VBA. Iíve seen so many vba codes online, but I donít
seem to understand it well enough to apply it in my situation.
the fields in the BOM table are the Following

ParentItemNumber ChildItemNumber QuantityPer
Oct 30 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.