How do I repeat

[sparkle]

I am using Access 2003
I have an attendance db for recording 'last minute' leave, eg. someone is sick or has to care for thier child.
The db records the usual name date etc.. but sometimes people will be away for 2,3,4 or even 5 days.
My Boss wants a report daily.
The form has a date picker for the first day of leave (usually today) and then a dropdown with options 1-5 for the number of days off.

If I record on Monday that somebody will be sick for 3 days this shows up as a total of 3 sick days for Monday.

Is there a way to have access interpret the number 3 (days off) as an instruction to create a new record for 1 day-off on 3 consecutive days? :banghead:

 

[vbaInet]

Using your example of 3 days off why does it need to create 3 separate records just to indicate that a person is off? I would have thought that you would send one daily report containg the names of those off, the number of days they took off and the start date and end date of the leave.

To answer your original question, Access cannot interpret that to mean it needs to create 3 records. You would have to write code to do that.

 

[sparkle]

Using your example of 3 days off why does it need to create 3 separate records just to indicate that a person is off? I would have thought that you would send one daily report containg the names of those off, the number of days they took off and the start date and end date of the leave.

To answer your original question, Access cannot interpret that to mean it needs to create 3 records. You would have to write code to do that.

I need to be able to run reports in arrears that identify DoW patterns etc. I thought the code was what made access interpret stuff ?

 

[vbaInet]

Using your example of 3 days off why does it need to create 3 separate records just to indicate that a person is off? I would have thought that you would send one daily report containg the names of those off, the number of days they took off and the start date and end date of the leave.

You didn't make any comments re the above.

 

[pervez]

I want also some fields that will repeat the previous value. I want to explain here. I have field for
Name, Designation , workplace. and Working hours An employee work 3 to 4 places daily. I want that the name and designation should remain intact and I should update workplace and timing instead of I type 3 to 4 time employee name. I will be grateful for quick answer.

 

[vbaInet]

I want also some fields that will repeat the previous value. I want to explain here. I have field for
Name, Designation , workplace. and Working hours An employee work 3 to 4 places daily. I want that the name and designation should remain intact and I should update workplace and timing instead of I type 3 to 4 time employee name. I will be grateful for quick answer.

Quick answer: please create your own thread.