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
|
|||
|
|||
making an equation in access
Hi, I would like to create a field that works out a formula based on other
fields. i.e field z=field4, when field 1field 2 - field 3 etc. Yes, it may be a silly question but I am only new to this....Thanks, Dani. |
#2
|
|||
|
|||
making an equation in access
Dani,
recommend against creating a "field" in a table and storing this value. One of the generally accepted rules of relational database development is not to store a "computed" (any value that is based on the value of other fields in your database) value in the table. It is a waste of database space, and will eventually result in bad data (when someone manually changes a value, but forgets about the computed field). It is better to use a query to create this computed value, and return that value whenever it is needed. If you would lay out the logic for us, I'm sure someone will be happy to help you write an IIF( ) statement or a function that will return the appropriate value. ---- HTH Dale "Dani." wrote: Hi, I would like to create a field that works out a formula based on other fields. i.e field z=field4, when field 1field 2 - field 3 etc. Yes, it may be a silly question but I am only new to this....Thanks, Dani. |
#3
|
|||
|
|||
making an equation in access
-- fatsultan "Dani." wrote: Hi, I would like to create a field that works out a formula based on other fields. i.e field z=field4, when field 1field 2 - field 3 etc. Yes, it may be a silly question but I am only new to this....Thanks, Dani. |
Thread Tools | |
Display Modes | |
|
|