Unanswered: Automatically calculated field contents
I have two fields that take their values from other fields. Currently the calculations are done in an Excel spreadsheet.
I believe it can be done in Access but do not have the Access knowledge to do it.
I want to add together the value of the fields from all specified records (would have to be pulled out using a query). Then a calculation done with the sum, then the answer be put in a field of a record in another table.
You should not store calculated results in your table. This result becomes "Static" and will not be correct if any values the result is based on is altered. Your result should be calculated "Dynamically" when needed so you can be absolutely sure that the result is correct at the time of execution.