How can I create a column using fomulars

[chuks79]

Hi,
I just started using Access not too long ago, and I need your advise on
how to add a new column (Column C) in my in an already exisitng table.
however, I want the value in this Column Ci to be derived from
muliplication of values in Column Ai and Column Bi. Any help will be
very appreciated.

 

[fredg]

Hi,
I just started using Access not too long ago, and I need your advise on
how to add a new column (Column C) in my in an already exisitng table.
however, I want the value in this Column Ci to be derived from
muliplication of values in Column Ai and Column Bi. Any help will be
very appreciated.

On the first line of a new column, write...
Result:[FieldA]*[FieldB]

The data returned in the [Result] column (column C) is not to be
stored in any table. When ever you need the product of FieldA and
FieldB in a query, repeat the above calculation.
Or if you need the result in a form or report, use an unbound control.
Set it's control source to:

=[FieldA]*[FieldB]