calculations in queries

[timmie]

I'm quite new to database work so this might be a really simple thing;
I'm trying to find a way to store the results of calculations that I have run in a query - is there a way of updating the results of the calculations into the underlying table?
If I cant actually store the information in the table - any ideas of how to get around this?

 

[Mile-O]

You shouldn't store the results of a calculation in a table as it should always be possible to provide these calculated results through a query.