Storing data from a calculation in a table

[ejyetter]

I've poked around and found that an expression I make in a form is unbound to
the table where I would like it stored. Other posts have stated that method
is a waste of disk space and it's better to do in a query or leave it in the
form. Here's my problem:

I have 200 subjects that complete a long survey. Each survey gets totaled
up. I have it so I can see what the total is in the form for each subject.
I need to pull these totals (not the individual numbers that went into each
total) for each subject either into a query, a table, or SOMEWHERE I can get
all the total scores together so I can export it. I do not want the sum of
all the sums.

Is this possible?

 

[Tom van Stiphout]

On Fri, 22 Feb 2008 18:36:01 -0800, ejyetter

Perhaps a simple query will do. Something like this:
select Subject, Sum(TheFieldToSum)
from TheTable
group by Subject

This would give you the sum per subject, thanks to the Group By
clause.

Indeed you don't seem to have a strong case for redundantly storing
the totals in a table.

-Tom.

 

[Ken Sheridan]

Redundancy is not merely a question of wasted disk space, its dangerous as it
leaves the table wide open to inconsistent data. Create a simple query as
Tom suggests and export the result of that.

Ken Sheridan
Stafford, England