Results 1 to 3 of 3
  1. #1
    Join Date
    May 2008

    Adding 2 fields together


    I'm completely new to access and am designing a database to keep control of my stock. My business is dependant on sending goods in the mail and so I need to be able to add cost of goods to cost of postage to check that the retail price is profitable. I imagine there is a way of getting the database to do this for me rather than manually entering the calculated amount but I dont know how to do this. I'm sure this is a very simple question for experienced users, but I have never designed a database before.

    Please can somebody point me in the right direction?
    Many thanks.

  2. #2
    jlclark4 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Dec 2010
    North Carolina
    You'll need to set up a query and create a new field. Include what you need in the query from other tables.

    New Field (which can be added directly to the query)

    NewField: [Cost of Goods] + [Cost of Postage]
    Right click to turn totals on and then Group By Expression.

    See if that works.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Ottawa, Ontario, Canada; West Palm Beach FL
    Can you show us a picture of your tables and relationships?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 11-06-2008, 12:29 PM
  2. Adding a single record
    By kfoyil in forum Forms
    Replies: 2
    Last Post: 11-22-2006, 09:12 PM
  3. adding list to a listbox
    By jetrow in forum Access
    Replies: 0
    Last Post: 08-15-2006, 03:36 AM
  4. Adding a Form to a web page
    By JohnnyO in forum Forms
    Replies: 3
    Last Post: 02-24-2006, 12:29 PM
  5. Adding Controls to a Form
    By msmayhew in forum Programming
    Replies: 7
    Last Post: 12-14-2005, 03:26 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums