How can I create a column using fomulars

  • Thread starter Thread starter chuks79
  • Start date Start date
C

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.
 
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.
Click to expand...

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]
 
Back
Top