I'm trying to create a Parts List/Bill of Materials in Access 2003.  I am 
somewhat of a new user and having difficulty building the database.  I'll see 
if i can describe what 'm trying to accomplish.  The alphanumerics below are 
part numbers.

i have a list of final products:(this list can be up to 5000)
P1000
P1001
P1002

Each product is made up of different components (this list can be up to 300)
C1
C2
C3

Each component is made up of different parts(this list can be up to 200)
L1
L2
L3

Example:  P1000 uses (2)C1's and (4)C3's.  C1 uses (1)L2 and C3 uses 
(2)L2's, (1)L1 and (1)L3

Each product can be made up of different types and quantities of components 
and each component can use different types and quantities of parts.

I need to count the amount of Parts(L#'s) in each product

Please help!

On Sun, 10 Jan 2010 19:00:01 -0800, CCD
<CCD@discussions.microsoft.com> wrote:

Maybe this will help:
http://www.mvps.org/access/modules/mdl0027.htm

-Tom.
Microsoft Access MVP


>I'm trying to create a Parts List/Bill of Materials in Access 2003.  I am 
>somewhat of a new user and having difficulty building the database.  I'll see 
>if i can describe what 'm trying to accomplish.  The alphanumerics below are 
>part numbers.
>
>i have a list of final products:(this list can be up to 5000)
>P1000
>P1001
>P1002
>
>Each product is made up of different components (this list can be up to 300)
>C1
>C2
>C3
>
>Each component is made up of different parts(this list can be up to 200)
>L1
>L2
>L3
>
>Example:  P1000 uses (2)C1's and (4)C3's.  C1 uses (1)L2 and C3 uses 
>(2)L2's, (1)L1 and (1)L3
>
>Each product can be made up of different types and quantities of components 
>and each component can use different types and quantities of parts.
>
>I need to count the amount of Parts(L#'s) in each product
>
>Please help!

thanks!  that worked

"Tom van Stiphout" wrote:

> On Sun, 10 Jan 2010 19:00:01 -0800, CCD
> <CCD@discussions.microsoft.com> wrote:
> 
> Maybe this will help:
> http://www.mvps.org/access/modules/mdl0027.htm
> 
> -Tom.
> Microsoft Access MVP
> 
> 
> >I'm trying to create a Parts List/Bill of Materials in Access 2003.  I am 
> >somewhat of a new user and having difficulty building the database.  I'll see 
> >if i can describe what 'm trying to accomplish.  The alphanumerics below are 
> >part numbers.
> >
> >i have a list of final products:(this list can be up to 5000)
> >P1000
> >P1001
> >P1002
> >
> >Each product is made up of different components (this list can be up to 300)
> >C1
> >C2
> >C3
> >
> >Each component is made up of different parts(this list can be up to 200)
> >L1
> >L2
> >L3
> >
> >Example:  P1000 uses (2)C1's and (4)C3's.  C1 uses (1)L2 and C3 uses 
> >(2)L2's, (1)L1 and (1)L3
> >
> >Each product can be made up of different types and quantities of components 
> >and each component can use different types and quantities of parts.
> >
> >I need to count the amount of Parts(L#'s) in each product
> >
> >Please help!
> .
>