Hi everyone, I just joined the group but I have very limited knowledge of Access. Basically I input data for a food pantry every month. Each year the database is copied and retains all records. There are three tables and one of them should have the information in the columns deleted. The columns are strictly used to record dates of visits and change from year to year. I would like to know if it is possible and how to do it to save me from deleting each entry to set up the database for 2007. Hope this makes sense. As you can see, I am a real novice and any help you can give me would be truly appreciated.
Lisa
