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
|
|||
|
|||
Calculating A Field Value
I want to add a field called Payments to a table. The value of this field is
calculated by multiplying the Days field and the Fee field together (the Days and Fee fields are both in the same table as the Payments field). Could any one point me to information on how to set this up? Thanks, Malcolm |
#2
|
|||
|
|||
Malcolm
Consider an alternative approach. A review of this newsgroup will reveal a frequent response to requests for "calculated fields" in tables -- DON'T! If you have the terms and factors needed to derive the calculated value, you don't need to store it. And storing a calculated value opens a new set of complications that you rarely need (or want) to deal with. Instead, create a query on the table. In the query, do your calculation. Now the calculated value is available to any form, and (other) query, and any report that needs that calculated value. Good luck! Jeff Boyce Access MVP "Malcolm Hegarty" wrote in message ... I want to add a field called Payments to a table. The value of this field is calculated by multiplying the Days field and the Fee field together (the Days and Fee fields are both in the same table as the Payments field). Could any one point me to information on how to set this up? Thanks, Malcolm |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
DCount compare table.textfield to form.text field question | RNUSZ@OKDPS | Using Forms | 1 | March 11th, 2005 02:05 AM |
Syntax needed to get needed reports | Frank Lueder | New Users | 15 | January 6th, 2005 08:39 AM |
Calculating a Form Field..Can it do it automatically? | AndreaL | General Discussion | 1 | September 29th, 2004 02:03 PM |
Calculating and Filling a Field Automatically. | Phil G | Using Forms | 1 | September 8th, 2004 08:17 AM |
field manipulation | Steve | Running & Setting Up Queries | 2 | May 28th, 2004 03:12 PM |