You shouldn't store calculated data in a table. It's a waste of storage space
and defies normalisation. Read up on normalisation, it's not just for
advanced users as i used to think.
You should calculate this data only when you want to display it, eg in a
report, on a form or in a query. If you end up using this calculation alot,
it might be worth learning how to write a VBA function to do it. Then you'd
only have to call the function each time you wanted to run the calculation.
Can't be done. It's a database; not a spreadsheet.
You need to do it in a query. Tables should just store data. Queries, forms,
and reports can be used to manipulate the display of such data.
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.
