November 12th, 2012, 03:39 PM
Calculating total cost using costs from different tables
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.
November 12th, 2012, 08:29 PM
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.
November 13th, 2012, 07:57 AM
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.
November 13th, 2012, 11:10 AM
Empty folder, nothing there....