R
Randy
I am trying to figure out a way to run a blance of hours from one month to
the next month. I have a form with a subform and a record source of
"EmployeeHourstbl" The subform lists Month, year, CTO Earned, CTO Used,
EID, etc. and what I need is a CTO Balance that caries over from the
previous month that shows a continual running CTO Balance. I hope this
makes sense. Thanks...Randy
CTO CTO CTO
Hours Earned Hour Used Hrs. Balance
JAN 2004 10.0 5.0 5.5
FEB 2004 5.0 2.0 8.5
the next month. I have a form with a subform and a record source of
"EmployeeHourstbl" The subform lists Month, year, CTO Earned, CTO Used,
EID, etc. and what I need is a CTO Balance that caries over from the
previous month that shows a continual running CTO Balance. I hope this
makes sense. Thanks...Randy
CTO CTO CTO
Hours Earned Hour Used Hrs. Balance
JAN 2004 10.0 5.0 5.5
FEB 2004 5.0 2.0 8.5