Calculating totals with a form

  • Thread starter Thread starter Bill Mills
  • Start date Start date
B

Bill Mills

I have a form with 16 text boxes arranged with 4 boxes
across and 4 boxes down. The boxes going down are
labeled "Personnel", "Equipment", "Supplies", and "Air
Support". The 4 boxes across are
labeled "DNR", "Federal", "Other", and "Private". What I
want to do is query a table that has three values, the
type of resource (i.e. personnel, equipment, etc.), the
agency (i.e. DNR, federal, etc.), and the total cost.
Then sum up the total costs for each of those text boxes.
So for example, I want to sum all of the total costs for
DNR personnel, sum all of the total costs for DNR
equipment, etc. I want to do that for each of the 16
boxes. Can anybody help me with the best way to do that?
Any help would be greatly appreciated.
 
you could use dsum to fill each control or set the forms recordsource to a
summary query. look in online help for syntax and use.
HTH
 
Back
Top