Question - Appropriate use of Queries

[faythe1215]

I'm just a little confused as to when it'll be best to have a field stored on a table vs on a query.

I have a table (tbl1Recipes) that has information such as the yield and recipe instructions, but I also have a form that calculates the cost for that recipe. Should I have that information stored on the main table or would it be more appropriate (as it is a calculated field) to have it on a query? Is there a benefit to one as opposed to the other?

[June7]

Normally, calculated data would not be saved. Nor would data be duplicated between tables - e.g. the ingredient prices. However, prices change. If historical pricing is not an issue, then just calculate the costs when needed.