multiply fields in a table

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

I have a very specific question.

I have a table with numeric values in field 3 & 4. I
need to multiply these fields to create an additional
field in the same table.
 
-----Original Message-----
I have a very specific question.

I have a table with numeric values in field 3 & 4. I
need to multiply these fields to create an additional
field in the same table.
.
Click to expand...
Storing a derived value into the table is generally
against the norm of relational database. You could get the
result when you retreat them by:
Select field3, field4, field3*field4 as multipliedResult
from ...
That has been said, you could use make-table query to get
the product into your table.
 
So my table, which is already propogated, is
called 'sides', and the 2 fields in 'sides' I want to
multiply are called 'x' and 'y', and need a table that
will give me product of x & y.

Is this code correct?

SELECT
sides.[x],
sides.[y],
sides.[x]*sides.[y] as multipliedResult
from sides;

What is the best recommendation, to create a new table,
through a select query? Or is there another option.

KISFS (keep it simple for stupid)

Steve
 
Back
Top