making an equation in access

[Dani.]

Hi, I would like to create a field that works out a formula based on other
fields. i.e field z=field4, when field 1<field 2 - field 3 etc. Yes, it may
be a silly question but I am only new to this....Thanks, Dani.

 

[Dale Fye]

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.

 

[fathi hassan]

--
fatsultan