Link a calculation to a field item

[Dubbs]

I am currently designing a database and two of the field criterion are going
to be safe and unsafe. I want to assign 5 pts for every safe when
observations are entered into the database. The safes need to be total and
averaged out of the total possible points after each audit entry. How do I
link this up to safes, total and average? Please help

Regards

Dubbs

 

[Jeanette Cunningham]

Hi Dubbs,

One of the important rules of database design is that totals and averages
are not stored in tables in the database.
When you want to show total and average safes in a form or report, base the
form or report on a query that calculates the totals and averages for you.

I assume you have a form where users enter their observations.
When a user enters an observation, if it passes the test for safe, the
control for safes can be given the value of 5.
This means that in your table of observations, you will see 5 in the field
for safes for every observation that passed the test for safe.

In a query that includes obersvations and safes, it is possible to get the
total for safes and the average for safes.

Post back if you need help to do this.

Jeanette Cunningham