Total cost stored in a field

  • Thread starter Thread starter vb_Dumb
  • Start date Start date
V

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
 
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.
 
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.
Click to expand...

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