Multiplying two Columns

  • Thread starter Thread starter BobbyPS2805
  • Start date Start date
B

BobbyPS2805

How do I Multiply Column A, Column B, and Column D within a table? I want
the product to go in Column F within the same table.

The data is well over 65K rows so I cant copy and paste.

Also.. A querey is tough because some cells in Column D have no value. (The
querey recognizes this as 0 thus making the entire product 0.
 
There really is no reason to do that. A basic rule of database
normalization is to not store calculated values. You can calculate them
when you need to present them on a form, on a report, or in a query if you
need to export the data.

It is not that the empty field is being seen as 0, it is actually Null.
Calculations with Null values will return Null. You can avoid that by
converting a Null to a 0 or some other value if necessary using the Nz
function
Nz(SomeField, 0) will return the actual value if it is not Null, and 0 if it
is. The 0 can be whatever value you need it to be including data types
other than numeric.
 
Back
Top