Great community. Great ideas.
Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.
November 12th, 2012, 04: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, 09: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, 08: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, 12:10 PM
Empty folder, nothing there....
By Advv in forum Microsoft Access Help
Last Post: July 23rd, 2008, 08:18 AM
By kunoichi in forum Microsoft Access Help
Last Post: January 3rd, 2005, 10:08 PM
By belbo_bagins in forum Microsoft Access Help
Last Post: December 8th, 2004, 05:05 PM
By ausjoe in forum Microsoft Access Help
Last Post: September 21st, 2004, 09:09 AM
By learnasugo in forum Microsoft Access Help
Last Post: July 21st, 2004, 03:06 PM