I'm creating employee vacation database and want to add 2 days to vacation days at the end of each month. How do I do this? Thanks in advance for your help.

You need to keep this data in a seperate table, then run an update query at the end of each month. Put a date stamp on each new entry. Have the update query code check to make sure you are not double entering the vacation days by checking the update date month against the current or last month.
Then report on vacation days with another query that totals them all up.
You don't want to have one figure that you are changing every month, like this:

mmcdonal 2 days (DELETE 2 and replace with next value)
mmcdonal 4 days (DELETE 4 and replace with next value)
mmcdonal 6 days (etc)
etc.

You want to do this:
April 2005 mmcdonal 2 days
May 2005 mmcdonal 2 days
June 2005 mmcdonal 2 days

Then your query/report/form will show a TOTAL of 6 days.

HTH

mmcdonal

Sorry, not an update query but an APPEND query.

mmcdonal

If you use this method then it is easy to remove spent days (and keep a record of them) using another table and another query to total and subtract. (Total accumulated vacation days in one table, total used vacation days in another or same table with a used switch, then subtract used from accumulated.)


mmcdonal

Thanks mmcdonal for your help. I will let you know the outcome.