Calculating total cost using costs from different tables

[easyonthetush]

Hi all. I'm a business owner and I make cloth diapers. I'm having trouble getting access to calculate my product cost.

I measure everything in square inches because I make different products that require different amounts of fabric.

I have a table that lists all the different products I make and the amount of fabric / each piece that is required for that product. I have several tables for the different components I use (a decorative fabric, the inner fabric, elastic, snaps, etc). The cost of each product is dependent on the components chosen. Not every component is used in a product.

I need a way to have Access calculate the cost of the product based on the components chosen. I'm assuming I need to create a query, but I haven't figured out a way to tie all of this together.

[June7]

Need to know your data structure. If you want to provide db for analysis, upload to a fileshare site such as Box.com and post link to the file. Omit the http:// prefix.

[easyonthetush]

www.box.com/files/0/f/0/1/f_3966584652

Here is a link to my database. Hopefully the link works. I will admit this might be the entirely wrong way to go given that the last time I really worked with Access was as a sophomore in College 5 years ago.

[meratigoerr]

Empty folder, nothing there....