C
Chris61
Hello,
Here is my issue with 2 forms.
Form A:
Contains work schedule: date, time in, time out, overtime, etc. At the end
of the 1st record, the total amount of time is totalled as hours worked.
Form B:
Contains productivity for the entire week.
What I would like to do is the following:
I want to reference the cumulative hours worked for the week by filtering
out all the other dates that I do not select and taking the total amount of
hours worked during the period that I select. I have two date areas (Week
Begin and Week End). These would be my period. From there, I want the total
amount of hours worked from Form A (for the period I determine) to appear in
the field in Form B.
Would anyone have any ideas?
I am currently using ACCESS 2007.
Thank you.
Here is my issue with 2 forms.
Form A:
Contains work schedule: date, time in, time out, overtime, etc. At the end
of the 1st record, the total amount of time is totalled as hours worked.
Form B:
Contains productivity for the entire week.
What I would like to do is the following:
I want to reference the cumulative hours worked for the week by filtering
out all the other dates that I do not select and taking the total amount of
hours worked during the period that I select. I have two date areas (Week
Begin and Week End). These would be my period. From there, I want the total
amount of hours worked from Form A (for the period I determine) to appear in
the field in Form B.
Would anyone have any ideas?
I am currently using ACCESS 2007.
Thank you.