Please help me find some direction

[Preston]

Hi,
I have been creating a database that generates timesheets for technicians
based on a given date range and filter criteria. I have a question and am not
sure how to proceed. If there is unpaid time for a technician that is prior
to the week we are generating the timesheet for I want to be able to decide
whether or not to include this time. If I don't then the time will be lost
and the user will not have another chance to pay the technician for this
time. As it works right now the user selects the tech he/she wants timesheets
for and gives a weekending date (sunday) the db then generates a report
(timesheet) for each tech based on the week ending on the date specified.
This is done using a recordset and a loop to filter a report. I would like
the user to be prompted if there is time prior to this week. If there is time
unpaid prior to the given week then i would like the user to have the choice
of selecting (by using a checkbox) each instance of time that they would like
to pay (include on the timesheet report).
I'm not sure how to tackle this. Should i build a temporary table with
the records prior to the date range and then present this in a form with
checkboxes? Should i simply use a recordset to handle the question? Any help
you can give will be greatly appreciated.
Thank you,
Preston

 

[Klatuu]

Why not just a query filtered for records with unpaid time with dates prior
to the current week as the record source of a form?

 

[Preston]

thank you for the response. i thought about that and it would be the quickest
and easiest solution. However, i would like to give the user the option to
select the time that he/she wants to include on the timesheet that is going
to be paid out. i've seen this type of functionality in quickbooks when
paying bills for example and i thought it would be a very nice touch to the
database. if i can't get it to work though, i will run a query for dates
prior AND unpaid
thank you
Preston

 

[Klatuu]

If you include the fields for the user to enter the time, they should be able
to. Using a query does no preclude modifying data unless for some reason you
end up creating an uneditable recordset.

 

[Preston]

OK i will see if i can get it to work.
thank you,
Preston