Can I multiply 2 fields?

  • Thread starter Thread starter Jimmy
  • Start date Start date
J

Jimmy

Hello in a table I have 3 fields. "Price/Unit" "Units" and a field called
"Total". I need "Total" to be =[Price/Unit]*[Units] . So I need to multiply
those fields. Is it possible in the table?
Jimmy
 
Not in your table, but it is easily done in a query. Simply enter your
formula in one of the fields in the query grid.
 
Jimmy,

No, you don't do calculations in a table. More importantly, you don't want
to! You can make the calculation anywhere (query, form, report or whatever)
anytime you need the value, so storing it is redundant.
Just for the record, if you really needed to store it, you would use a
calculated field in an update query.

HTH,
Nikos
 
Back
Top