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
|
|||
|
|||
Columns with formulas...
Hi,
Is it possible to have a formula in a column? Eg. I have three columns A, B, C. I want the value of C to be the sum of A and B. How do I specify such formulae? ....Sinex |
#2
|
|||
|
|||
you don't enter calculations in table fields. normally, you also don't save
the results of calculations in table fields. instead, you save the raw data in one or more tables, then create a calculated field in a query to display the value, as C: A + B hth "Sinex" wrote in message ... Hi, Is it possible to have a formula in a column? Eg. I have three columns A, B, C. I want the value of C to be the sum of A and B. How do I specify such formulae? ...Sinex |
#3
|
|||
|
|||
The best way to accomplish your goal is to place Columns
A and B into your table. Then, create a query with a calculated column: For example, TableNew FieldA: 3 44 FieldB: 5 10 Now create a query that pulls both fields and place your calculated field in the 3rd column of the query: Say for example: MyCalcField:[FieldA] + [FieldB](This would be typed into the top row of column 3 in the design grid of the query exactly as above. When you run the query, each row will calculate the MyCalcField value.It would look like this: FieldA FieldB MyCalcField 3 5 8 44 10 54 -----Original Message----- Hi, Is it possible to have a formula in a column? Eg. I have three columns A, B, C. I want the value of C to be the sum of A and B. How do I specify such formulae? ....Sinex . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking with multiple formulas | jwr | Links and Linking | 2 | April 11th, 2005 02:13 PM |
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | foofoo | General Discussion | 1 | April 2nd, 2005 12:02 AM |
Time scale makes columns too narrow | George Marshall | Charts and Charting | 1 | April 10th, 2004 05:10 AM |
Dual-axis With Columns? | dchem | Charts and Charting | 1 | February 11th, 2004 04:08 PM |
Copying formulas with ranges | Carla S | Worksheet Functions | 2 | December 18th, 2003 07:06 PM |