Notices

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.

Thread: Calculating total cost using costs from different tables

Results 1 to 4 of 4
Share This Thread →
  1. #1
    easyonthetush is offline 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
    June7's Avatar
    June7 is offline Moderator
    Join Date
    Apr 2009
    Location
    The Great Land
    Posts
    4,618
    Rep Power
    649
    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

  3. #3
    easyonthetush is offline 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.

  4. #4
    meratigoerr's Avatar
    meratigoerr is offline Contributing User
    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    58
    Empty folder, nothing there....

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

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

ASP Free Advertisers and Affiliates