update query to add total to orders table

[AlexB1]

would it work using an update query to put a calculated field from another query into a table ?

for example:
i have an active orders table which needs to include sub total and total. these 2 fields are calculated in another query...but considering this will be heavily used i dont know if it will be suitable never mind if it will work

anyone able to point me in the right direction ?

 

[MSAccessRookie]

would it work using an update query to put a calculated field from another query into a table ?

for example:
i have an active orders table which needs to include sub total and total. these 2 fields are calculated in another query...but considering this will be heavily used i dont know if it will be suitable never mind if it will work

anyone able to point me in the right direction ?

Probably not.

To your Question:

As long as your user access is properly defined (Split Front End/Back End, etc), there should not be any problems except perhaps some slowness due to heavy usage and/or Network issues.

HOWEVER:

As a rule, there is never a need to store any calculated data in a table, since the overhead to recalculate is far less than the overhead to store the new data. You can base your Forms and reports on Queries that perform the calculations when they are needed as opposed to Tables that have stored calculations that may or may not be out of date.

-- Rookie

 

[AlexB1]

Probably not.

To your Question:

As long as your user access is properly defined (Split Front End/Back End, etc), there should not be any problems except perhaps some slowness due to heavy usage and/or Network issues.

HOWEVER:

As a rule, there is never a need to store any calculated data in a table, since the overhead to recalculate is far less than the overhead to store the new data. You can base your Forms and reports on Queries that perform the calculations when they are needed as opposed to Tables that have stored calculations that may or may not be out of date.

-- Rookie

well once its stored in the table it should never need to be calculated again...very rarely will it need to be altered...but there will be a large number of them saved...

i thought saving the calculated fields would be easier than having them calculated on multiple forms and reports...but then i am new to access