J
Johnny
Hello everyone,
I have a table called "Holidays" where all the employees holidays are
stored! At this moment 2008 holidays are stored.I wish, when entering
2009 to copy all the records from "holidays" table to a new table
(archive) and clean up the "holidays" table.
So far I'm thinking of make a new table using a make table query with
records from "holidays" table, the problem is, I want this to be done
dynamically without user intervention.The idea is, at the first time
the user open the DB in 2009 the code runs and do all on the fly.
The new table name would be "Holidays" & year(date())-1).
This way when 2010 cames the same will happen and I'll get one
Holidays table for each year.
Any help woukd be appreciated, including other ideas to achiev this
Thanks in advance
Johnny
I have a table called "Holidays" where all the employees holidays are
stored! At this moment 2008 holidays are stored.I wish, when entering
2009 to copy all the records from "holidays" table to a new table
(archive) and clean up the "holidays" table.
So far I'm thinking of make a new table using a make table query with
records from "holidays" table, the problem is, I want this to be done
dynamically without user intervention.The idea is, at the first time
the user open the DB in 2009 the code runs and do all on the fly.
The new table name would be "Holidays" & year(date())-1).
This way when 2010 cames the same will happen and I'll get one
Holidays table for each year.
Any help woukd be appreciated, including other ideas to achiev this
Thanks in advance
Johnny