Table Field Design Help !!!

[usermj]

Recently I'm helping a friend to convert his MS-Excel spreadsheet into MS-Access. I met a problem and need some help on defining the table fields.

In one of spreadsheets, he gets 3 columns, the 3rd column values is calcuated by a formula based on the previous two entries as the followinf: D3= C3+B3

When I tried to turn this table into MS-Access design, I don't know how to define the 3rd column (field).

Is there any chance I can set any expression/formula for 3rd field in the table defnition to retrieve data from previous columns( I don't want to design this function in the query)?

Many thanks

 

[wazz]

don't store a calculation. it can be calculated any time, anywhere.
if you want the result on a form, it's as easy as putting this
=[YourField1]+[YourField2]
in the control source of an unbound text box.