Access tables?

I am trying to create tables in access that have certain features that would normally be used in excel. i was wondering if it is possible to get two fields and multiply/add/subtract them together. like: one field will have company revenue and another will have company expenses. i wanna make a third field that calculates company revenue - company expenses. show an overall profit! im trying to do this on access, in tables. i know that you can do this in queries but im not sure how to do this on tables. i have a brief idea that i might have to use a code or soemthing in the validation settings. thanks~

Answer

Use a query to do the arithmetic. create a new query in design view and add the fields you wanna have the arithmetic. then create a new field by doing the following: in the criteria cell, type the field's name a colon, and the equation you wanna calculate. the new field only exists in the query - you cannot do math in a table field, and you can's create a new table field by running the query. you can use the new field in a report or form by using the query as your data source - use the wizard to generate the form ir report. for more details, check out these two questions: http://answers.yahoo.com/question/index;_ylt=ahfiz5hdfkjjiwzzlfl32pzsy6ix?qid=20070124122944aawl2as http://answers.yahoo.com/question/index;_ylt=agbpicb8s8ch3jhmw0i_ox_sy6ix?qid=20070125104919aa5sjsb