Autocop and past when 2 values are the same

[FuzzFuzz]

Hi everyone.



Since I'm relatively new to databases, I thought it would help to sign up here.
So for my first question, I have a question about copying rows when 2 values match.

The situation is that I have a table in wich we keep track of people at work.
So, we keep track if they are late, sick, better, to long with coffebreak, etc.

Now the most interesting of these situations is the one called sick, because if a person is sick, it might very well be that he is going to be sick the day after as well.

the question is: is it possible to copy all the rows of every person who has reported (or still is) sick yesterday and copy these values to today automatically.

In the form itself, the date is already automattically updated, but I'm not sure if this would be of real importance.

thanks in advance.

Fuzz

[June7]

Yes, requires VBA code running INSERT SELECT sql action statement. Common topic. Do search in forum or Google.