#1
  1. No Profile Picture
    Registered User

    Join Date
    Nov 2012
    Posts
    2
    Rep Power
    0

    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.
  2. #2
  3. Moderator
    ASP Super Genius (4500 - 4999 posts)

    Join Date
    Apr 2009
    Location
    The Great Land
    Posts
    4,618
    Rep Power
    650
    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.
    I like to know if my suggestion helped you. One way to let me know is by clicking star at bottom left corner of post.
    Debug!Debug!Debug!http://www.cpearson.com/excel/debug.htm
  4. #3
  5. No Profile Picture
    Registered User

    Join Date
    Nov 2012
    Posts
    2
    Rep Power
    0
    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.
  6. #4
  7. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    58
    Empty folder, nothing there....

Similar Threads

  1. Calculating the total cost for an invoice in a report
    By Advv in forum Microsoft Access Help
    Replies: 2
    Last Post: July 23rd, 2008, 07:18 AM
  2. calculating records total
    By kunoichi in forum Microsoft Access Help
    Replies: 1
    Last Post: January 3rd, 2005, 09:08 PM
  3. calculating total cost
    By belbo_bagins in forum Microsoft Access Help
    Replies: 2
    Last Post: December 8th, 2004, 04:05 PM
  4. Calculating total in a subform
    By ausjoe in forum Microsoft Access Help
    Replies: 7
    Last Post: September 21st, 2004, 08:09 AM
  5. Calculating Total in Report
    By learnasugo in forum Microsoft Access Help
    Replies: 4
    Last Post: July 21st, 2004, 02:06 PM

IMN logo majestic logo threadwatch logo seochat tools logo