Can I multiply 2 fields?

[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

 

[Lynn Trapp]

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.

 

[Nikos Yannacopoulos]

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