S
Secret Squirrel
I have a table with the following fields in it:
VacID
VacDate
EmpName
Hours
What I'm looking to do it create a form that I use to enter this info into.
The table is used to track vacation days by employee. But there needs to be a
new record for each vacation day an employee takes. The problem is I want my
users to be able to enter a date range of vacation days and have it create
new records for each day. For example if an employee takes 08/25/08 thru
08/29/08 I want a new record created for each day for that employee. I could
have the users create a new record for each day but that seems a bit tedious.
I want them to be able to enter a starting date, and ending date and then
have records created for each day including the starting and ending dates.
Can this be done?
VacID
VacDate
EmpName
Hours
What I'm looking to do it create a form that I use to enter this info into.
The table is used to track vacation days by employee. But there needs to be a
new record for each vacation day an employee takes. The problem is I want my
users to be able to enter a date range of vacation days and have it create
new records for each day. For example if an employee takes 08/25/08 thru
08/29/08 I want a new record created for each day for that employee. I could
have the users create a new record for each day but that seems a bit tedious.
I want them to be able to enter a starting date, and ending date and then
have records created for each day including the starting and ending dates.
Can this be done?