Adding 2 fields together

[Craig Spencer]

Hi,

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.

[jlclark4]

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.

[orange]

Craig,
Can you show us a picture of your tables and relationships?