Steve

04-07-2002, 11:59 AM

I have an Access 97 database with 20 check boxes on it. There is a text box that counts the number of "yes" (-1) marks. I'd like the results of this to appear in the underlying database, in a field called [numerator].

Numerator works on the form, but the record source is the calculation: (that is -1*the sum of the values of the 20 check boxes. Clumsy? Maybe, but it works...) But because the record source is the calculation, the result doesn't appear in the Numerator field in the underlying database.

How do I get the result of the calculated field into the database?

Cheers,

Steve

Numerator works on the form, but the record source is the calculation: (that is -1*the sum of the values of the 20 check boxes. Clumsy? Maybe, but it works...) But because the record source is the calculation, the result doesn't appear in the Numerator field in the underlying database.

How do I get the result of the calculated field into the database?

Cheers,

Steve