hello everyone

im very confused how i will do this. actually i have to make a vb6 project on payroll and my computer instructor give me a tough problem to solve. i have to make financial year like april 2010 to march 2011 in my vb6 project. once it go to april 2011 then the project automatically make new financial year and save the old financial year so that later the financial year can be retrive and all the employee details must go to new financial year but other details like attendance and other things become zero or something like that so that the project starts from new financial year. also he told me to register daily attendance of all employee in my ms access file. these are two problems which i dont know how to solve because i have never did these kind of problem before. i made tables in my access file to store employee details but dont know how to do financial year or daily addendance. so i need the help on how to do these. any help or idea or suggestion will be greatly appreciated because i will get qualified only after i submit this project.