Can someone please respond to this question (1 Viewer)

I am building a report that has a part number that is the full kit. It breaks down into parts that are components. What I need to do is build queries that will break them down in price or a percentage of price or else it will give me the full price. Is there a way to do this in an easy way? I know this is pretty complex but if there is an answer out there it would be great. Basically, it goes like this:

You have a computer and all the parts come with it but here are the sub parts:
1) PC
2) Monitor
3) Mouse
4) Keyboard

These need to be broken down to a percentage so I can get a price.

[FONT=&quot]If you consider the fact that each of these components is a product by itself, it is also not too hard to consider that each of the products can also be a component of a larger system.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]For Instance:[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]A Computer System can consist of at least the following products:[/FONT]

• [FONT=&quot]Monitor (See Below for further details)[/FONT]
• [FONT=&quot]Keyboard[/FONT]
• [FONT=&quot]Mouse[/FONT]
• [FONT=&quot]Printer (See Below for further details)[/FONT]

[FONT=&quot] [/FONT]
[FONT=&quot]A Monitor can consist of at least the following products:[/FONT]

• [FONT=&quot]The Screen that you view[/FONT]
• [FONT=&quot]External Speakers[/FONT]
• [FONT=&quot]Power Cord[/FONT]

[FONT=&quot] [/FONT]
[FONT=&quot]A Printer can consist of at least the following products:[/FONT]

• [FONT=&quot]The Printer Device[/FONT]
• [FONT=&quot]Ink Cartridge(s)[/FONT]
• [FONT=&quot]Paper[/FONT]
• [FONT=&quot]Power Cord[/FONT]

[FONT=&quot] [/FONT]
[FONT=&quot]Note that a number of the components can also be priced and sold as independent products.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]The same can be said for the rest of the computer.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]What might work here is two tables:[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Products[/FONT][FONT=&quot]Table[/FONT]
[FONT=&quot]ProductID - AutoNum No Duplicates Allowed[/FONT]
[FONT=&quot]ProductName - Text No [/FONT][FONT=&quot]Duplicates Allowed[/FONT]
[FONT=&quot]ProductPrice - Currency [/FONT][FONT=&quot]Duplicates Allowed[/FONT]
[FONT=&quot]ComponentPrice - Currency [/FONT][FONT=&quot]Duplicates Allowed[/FONT]
[FONT=&quot].[/FONT]
[FONT=&quot]Other Stuff[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]ProductByComponents[/FONT][FONT=&quot]Table[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]ProductComponentID - AutoNum No Duplicates Allowed[/FONT]
[FONT=&quot]ProductID - Number ProductID from [/FONT][FONT=&quot]Products[/FONT][FONT=&quot]Table ([/FONT][FONT=&quot]Duplicates Allowed)[/FONT]
[FONT=&quot]ComponentID - Number [/FONT][FONT=&quot]ProductID from [/FONT][FONT=&quot]Products[/FONT][FONT=&quot]Table ([/FONT][FONT=&quot]No Duplicates Allowed)[/FONT]
[FONT=&quot].[/FONT]
[FONT=&quot]Other Stuff[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]You can see how the two prices could be used to price the individual units as well as the sets. I know this is very crude, but it is a beginning and perhaps you can take it from here[/FONT]

I have a table that's working but what I need to do is break it down into queries where I am getting the percentage of each component. I know that the organization has done it in the past maybe I can see a sample of some sort. I will see if I can gain access to these reports. Thanks, for your help.

ok - so you have the price of
monitor
keyboard
mouse
printer

and I presume a field called total
so
keyborad 150
monitor 75
mouse 10
printer 125

total 360 _On a report

now you can ue the total field as part of your calculation so (keyboard/total) * 100 = 41.67
monitor /total*100 = 20.83
its not that hard to work out on a report