G
Guest
I created a Db to track equipment man hrs and down time.
My question and delema is simple, " but not for me "
I have a form called " maintenance main"
A subform called " Equipment extention"
A subform in the equipment extention called " parts and labor"
this is what I am trying to do..
on the main form is "total hrs"
on sub form "equipment extention" is total hrs --this is for the sum value
in parts and labor
sub form parts and labor ( datasheet view) is field hrs
field on parts and labor "in the footer" total hrs control is =sum([hrs])
this works. I want the main form to add all the sums for equipment extention
so I can get a grand total of hrs for the whole machine and not just the
parts of it.
Thanlks and I know that you will neet some more codes
But please help
My question and delema is simple, " but not for me "
I have a form called " maintenance main"
A subform called " Equipment extention"
A subform in the equipment extention called " parts and labor"
this is what I am trying to do..
on the main form is "total hrs"
on sub form "equipment extention" is total hrs --this is for the sum value
in parts and labor
sub form parts and labor ( datasheet view) is field hrs
field on parts and labor "in the footer" total hrs control is =sum([hrs])
this works. I want the main form to add all the sums for equipment extention
so I can get a grand total of hrs for the whole machine and not just the
parts of it.
Thanlks and I know that you will neet some more codes
But please help