Storing calculated query results

[Dragon]

My database is used to track shipping and receiving for a warehouse with five
separate areas. The daily report needed has a breakdown by area and domestic
or export shipping.

To simplify the report, I would like to export my various query results into
another table with all the information (calculated totals for each parameter
as well as a few fields of user inputted data). This would be stored in a
single record by day.

Most everything I read says storing results of a query isn't a good idea, if
there is another viable solution, I'm open to suggestions.

 

[fredg]

My database is used to track shipping and receiving for a warehouse with five
separate areas. The daily report needed has a breakdown by area and domestic
or export shipping.

To simplify the report, I would like to export my various query results into
another table with all the information (calculated totals for each parameter
as well as a few fields of user inputted data). This would be stored in a
single record by day.

Most everything I read says storing results of a query isn't a good idea, if
there is another viable solution, I'm open to suggestions.

Storing calculated value is not a good idea.
There, I've said it again.....
Use the query as the reports record source.
If you need to calculate a value, calculate it in the query, or
directly in the report.

No need to create a separate table.
No need to store calculated values.

 

[John W. Vinson]

My database is used to track shipping and receiving for a warehouse with five
separate areas. The daily report needed has a breakdown by area and domestic
or export shipping.

To simplify the report, I would like to export my various query results into
another table with all the information (calculated totals for each parameter
as well as a few fields of user inputted data). This would be stored in a
single record by day.

Most everything I read says storing results of a query isn't a good idea, if
there is another viable solution, I'm open to suggestions.

You can use an Append query to append the data to a table.

You can use the *exact same query* as a Select query as the basis for your
report, without the overhead, bloat, and risk to data integrity of storing the
result. It'll run faster as well.

You gain *nothing* by storing the result!

If you have a *proven and demonstrated* need to do this, please explain.