smichaels1234
Registered User.
- Local time
- Yesterday, 21:31
- Joined
- May 12, 2008
- Messages
- 64
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.
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.