N
newbi
I have lots of problems..
I need to get a running total on the main form so here is the set up.
my main for keeps track of equipment
my sub1 form keeps track of the different parts of the equipment
my sub1.1 form keeps track of the man hrs and $ spent on the different parts
the main for needs to sum the " total hrs", "total hrs $", total parts$, and
grand total
the total hrs = spent on whole equipment -------this one works
to total hrs $= total spent on man hrs for this equipment---- does not work
here is how it setup.
main form
fields= equip #--total hrs- total hr $ - total parts cost - Grand total
sub form1 = equip #(to link) ext #(part of equip #) total hrs, total
hr$,total parts
subform1.1= equip #(to link) ext#(to link) emp,wage,hrs,part$,total hrs $
in the footer of subform1.1 i have field =sum([hrs]) "works"
in the detail of subform1.1 field name"total hrs $" =sum([wage]*[hrs])
"works" which in placed on subform1 in field =[total hrs $] this displays
total $ for that part of the equipment
but nee to sum all parts together and place on the main form
I have tried making a query but it return and -0- where it's suposed to sum
need help on caculating a calculated field because although
total=sum[wage]*[hrs] works =sum[total] returns error
main form "total hrs" works
main form total hrs $ return error
I need to get a running total on the main form so here is the set up.
my main for keeps track of equipment
my sub1 form keeps track of the different parts of the equipment
my sub1.1 form keeps track of the man hrs and $ spent on the different parts
the main for needs to sum the " total hrs", "total hrs $", total parts$, and
grand total
the total hrs = spent on whole equipment -------this one works
to total hrs $= total spent on man hrs for this equipment---- does not work
here is how it setup.
main form
fields= equip #--total hrs- total hr $ - total parts cost - Grand total
sub form1 = equip #(to link) ext #(part of equip #) total hrs, total
hr$,total parts
subform1.1= equip #(to link) ext#(to link) emp,wage,hrs,part$,total hrs $
in the footer of subform1.1 i have field =sum([hrs]) "works"
in the detail of subform1.1 field name"total hrs $" =sum([wage]*[hrs])
"works" which in placed on subform1 in field =[total hrs $] this displays
total $ for that part of the equipment
but nee to sum all parts together and place on the main form
I have tried making a query but it return and -0- where it's suposed to sum
need help on caculating a calculated field because although
total=sum[wage]*[hrs] works =sum[total] returns error
main form "total hrs" works
main form total hrs $ return error