If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
multiply fields in a table
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. |
#2
|
|||
|
|||
multiply fields in a 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. . 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. |
#3
|
|||
|
|||
multiply fields in a 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Name not showing ID is | René | Setting Up & Running Reports | 11 | June 29th, 2004 01:40 AM |
Image Control Table | John Gavin | General Discussion | 3 | June 28th, 2004 04:21 AM |
Import Fields from Word Table into access record | Gordzilla | General Discussion | 1 | June 17th, 2004 06:45 PM |
Select Table Fields for Export | [email protected] | General Discussion | 2 | June 17th, 2004 12:59 PM |
Combining data from multiple fields into Pivot table | Os | Worksheet Functions | 5 | June 1st, 2004 05:04 PM |