Text box

G

Guest

Hi,

I used tbl Score, which has Math, History, Accounting......and Total Scores
fields, to create the form that is used for entering students' scores.

For example, Math=1
History=2
Accounting=5
...
....
TotalScores: 8

The TotalScores text box sums all scores. I used the formular= SUM (.....).
It works fine. However, the total scores value (8) doesn't link back to the
table Score.

In the form, I see the # 8, but when I check the tbl Score, I dindn't see it
in the TotalScore column. Please help.
Thanks
 
F

fredg

Hi,

I used tbl Score, which has Math, History, Accounting......and Total Scores
fields, to create the form that is used for entering students' scores.

For example, Math=1
History=2
Accounting=5
...
....
TotalScores: 8

The TotalScores text box sums all scores. I used the formular= SUM (.....).
It works fine. However, the total scores value (8) doesn't link back to the
table Score.

In the form, I see the # 8, but when I check the tbl Score, I dindn't see it
in the TotalScore column. Please help.
Thanks

If by not seeing the score in a table field [Total Score], then that
is correct.
Total Score is a calculated value and should not be saved in your
table.
Any time you need the Total Score, simply re-calculate it as you are
now doing, on a form, in a report, or in a query.
 
G

Guest

This is how it should be.
Don't store the sum value in a table, you should use a group by query to sum
the records and display the current and acurate value.

Storing the total value mean that you need to maintain it, for example if
the value of one of the fields will be updated directly in the table, the sum
value wont update.

Just use a query to list the total for each student

If you need help with the query, please post back
 
C

Carl Rapson

Chi said:
Hi,

I used tbl Score, which has Math, History, Accounting......and Total
Scores
fields, to create the form that is used for entering students' scores.

For example, Math=1
History=2
Accounting=5
...
....
TotalScores: 8

The TotalScores text box sums all scores. I used the formular= SUM
(.....).
It works fine. However, the total scores value (8) doesn't link back to
the
table Score.

In the form, I see the # 8, but when I check the tbl Score, I dindn't see
it
in the TotalScore column. Please help.
Thanks

You don't need the TotalScore field in your table, because it's redundant
information and you can always easily regenerate it by summing the score
fields. This can be done in any query to display the total when you need it.

Carl Rapson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top