Can I multiply 2 fields?

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.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Jimmy" wrote in message
...
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

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

"Jimmy" wrote in message
...
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