Previous Year

From: scuba79 (scuba79_at_discussions.microsoft.com)
Date: 03/18/05 

Date: Thu, 17 Mar 2005 16:25:04 -0800

I have a client that is using Access 97, they want to be able to archive some
records, however, I need to make sure that the records that they are
archiving are not from the previous year and I need to code it so that it
will be automatic for each year...

Example:

2005 needs to keep all 2004 and 2005 records
2006 needs to keep all 2005 and 2006 records
and so forth...

What I would like to do is create a command button when clicked will look at
the current date and then make the determination of how far back to go....

Thanks in advance