Total cost stored in a field

[vb_Dumb]

I need a total cost field (Total cost of department) on the footer of
a form to calculate the sum of a field called total cost (Total cost)
for all the records but i need the total cost of department to be
stored in a field in a query any help would be great

 

[Beetle]

Data is stored in tables, not in queries, but calculated data such as
you describe should not (with very few exceptions) be stored, only
calculated when needed. You can do calculations in queries, but the
type of calculation you are talking about should just be done in an
unbound control in your form footer (which you are already doing).

You can use the same method in a report if you need to print the
data, but you should not attempt to store it in a table.

 

[vb_Dumb]

Data is stored in tables, not in queries, but calculated data such as
you describe should not (with very few exceptions) be stored, only
calculated when needed. You can do calculations in queries, but the
type of calculation you are talking about should just be done in an
unbound control in your form footer (which you are already doing).

You can use the same method in a report if you need to print the
data, but you should not attempt to store it in a table.

well i was just trying to avoid making a report do to lack of time but
thanks ill just make the report....