Proper database design would dictate that you do not store a calculated
figure in a table. When you need to use the number in a form, report, or
query, calculate it there.
If you will do some searches (before posting your question) you'll find this
same question asked and asnwered many many times. Some responses go into a
bit more detail.
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.
