All. I have a ms access 2003 database that has a month/year table for 2012 i.e. january 2012, february 2012 that is used on a form as drop down. i want to add a month year table that has future years. The user would run reports based on the month and year. I will also be archieving data every 90 days and every year. Is it best to set up the tbl with all the months and a separate tbl with the year and concatenate the month and year in the field the uses need?
I need something managable because eventually they need to select january 2013. By the way; I inherited this database as is.
Thanks