While you can't do the calculation directly in the table, there are a few things you can do:
A) If the data is manipulated through a form, you can change the field automatically whenever the record is updated or created
B) Run an Append Query to do all the work for you instead of manually...
Setup: We have a Microsoft Access DB that houses Testing. Each test has 10 questions with 4 multiple choice answers. We have a test table, a question table and an answer table with a FK linking them. The Questions are displayed in a subform on the Test form and the Answers in a subform...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.