C
ChrisA
I have a database that is used to track man hours worked each week on a
daily basis by members . The hours are input through an unbound form with
seven entries for each day of the week which are based on a weekending
date. This then creates a record for each day containing the hours, member,
amount and the date worked, jobnumber and timesheetID
We enter a number of members hours at one time for one job at a time and
then clear the form and start a new job. I would like to print a summary of
the records entered prior to starting the next job input. But not sure how
the handle a month where the entries as the start and end might span two
months. (ie: 31st March and the 1st April might be the same week)I can print
a report by month but this will miss any days at the beginingn or end that
fall outside of the current month.
The only way I can think to handle this is to add another field called say
"DataEntryDate" which would be the default current day we entered the
members hours in to the database and then printing the report based on this
date the the JobNumber as opposed the day worked.
Hope thats clear and appreciate any direction.
ChrisP
daily basis by members . The hours are input through an unbound form with
seven entries for each day of the week which are based on a weekending
date. This then creates a record for each day containing the hours, member,
amount and the date worked, jobnumber and timesheetID
We enter a number of members hours at one time for one job at a time and
then clear the form and start a new job. I would like to print a summary of
the records entered prior to starting the next job input. But not sure how
the handle a month where the entries as the start and end might span two
months. (ie: 31st March and the 1st April might be the same week)I can print
a report by month but this will miss any days at the beginingn or end that
fall outside of the current month.
The only way I can think to handle this is to add another field called say
"DataEntryDate" which would be the default current day we entered the
members hours in to the database and then printing the report based on this
date the the JobNumber as opposed the day worked.
Hope thats clear and appreciate any direction.
ChrisP