calculations

[matt shudy]

Hi,

Is there a way to calculate values inside a table? If I
have two cells "Hours" and "Incidents" and I want to
figure out the Incident Rate, I have to take
(Incidents*200000)/Hours , Is there a way to do this right
in the table, and not make a query? If so please explain
what I would have to do.

Thanks,

Matt

 

[Willem van der Berg]

Hi,

Is there a way to calculate values inside a table? If I
have two cells "Hours" and "Incidents" and I want to
figure out the Incident Rate, I have to take
(Incidents*200000)/Hours , Is there a way to do this right
in the table, and not make a query? If so please explain
what I would have to do.

Thanks,

Matt

I'm no expert myself, but I think it is not a wise idea to do this. It is
derivable data and you should never store that in your base table. If your
database is not too big the extra diskspace might not be that much of a
problem but the potential for faulty data making it's way into your database
is very real (change one of the two variables and forget to change the
calculation field...). I don't think it's possible to do what you would like
to do and for the reason just mentioned.
It is of course possible to make a query that's based on the table, add a
field which does the actual calculation and hiding the Hours and Incidents
fields. In essence that would be what you would like to do? If you want to
use a form to manipulate the data in your table you could also use the form
to make the calculations on the fly and show the result, no need to store
the result of the calculation in your original table.

Best regards,
Willem van der Berg.