G'day,
Being a very inexperienced user of MS Access, I am hoping I can get some help on here.
I have a databsae that is used to enter all in and outgoing correspondence. I need a way to tell the database when it opens to append the tables to an archive table when the new year rolls around.
Basically the query looks at the year and if the year is one less than the current year then it will append that table. But how do I get the DB to check the current year against the year in the table and tell the query to do what it has to do without having to resort to manual input. It needs to be automatic on start-up.
Field Name Data Type
Number (Autonumber)
Year (Date/Time - dd/mm/yy format)
Date Recieved (Date/Time - dd/mm/yy format)
Minute Dated (Date/Time - dd/mm/yy format)
Originator (Text)
Subject (Memo)
File (Text - List box)
Any help would be appreciated. Oh and it is MS Access 97
Being a very inexperienced user of MS Access, I am hoping I can get some help on here.
I have a databsae that is used to enter all in and outgoing correspondence. I need a way to tell the database when it opens to append the tables to an archive table when the new year rolls around.
Basically the query looks at the year and if the year is one less than the current year then it will append that table. But how do I get the DB to check the current year against the year in the table and tell the query to do what it has to do without having to resort to manual input. It needs to be automatic on start-up.
Field Name Data Type
Number (Autonumber)
Year (Date/Time - dd/mm/yy format)
Date Recieved (Date/Time - dd/mm/yy format)
Minute Dated (Date/Time - dd/mm/yy format)
Originator (Text)
Subject (Memo)
File (Text - List box)
Any help would be appreciated. Oh and it is MS Access 97