Mabe to Simple of a question

[ox0069]

This is my delema:

I'm making a score card. I wand the last field for each record to equal the summ of the previous fields. Can that happen or not

Russ

 

[Kraj]

It depends on what you're trying to do. The answer is "Yes, you can have a field in a table that stores a calculated value. But you shouldn't." The correct way to do it would be to create a query on the table and have that find the total, or to create a report on the query and calculate the total there.

But if all you are doing is creating a single-page grid where values are filled in and a total is calculated at the end, perhaps you should consider a spreadsheet instead of a database?

 

[ox0069]

This is for a Rifle team ans I want to ebe able to track scores over time to see improvements as well as other stuff. so how would i calucate with in the table??

 

[statsman]

Kraj is correct. Calculating the totals in the table would not be the best way to go in this situation.
My first choice in this situation is to keep track of the scores in a table. Enter the results for each competition with a date or other reference to time.
Create a query where the date is used to calculate the scores (past 2 competitions, past 10 competitions, past year etc.)