My database is well and truly set up and has been functioning for almost a year. however, i have recently noticed i made an error in my table creation as i forgot to include a year field.
i have a tblWeeksDates which includes the week numbers for this year 1 - 52 and the start date of each week.
the primary key is the week no.
i need these to be the week no.s for year 06/07.
i use the week no. field within most of my tables.
for the year 07/08 i need to be able to use the numbers 1 - 52 again however they have different week start dates.
any ideas?
i have a tblWeeksDates which includes the week numbers for this year 1 - 52 and the start date of each week.
the primary key is the week no.
i need these to be the week no.s for year 06/07.
i use the week no. field within most of my tables.
for the year 07/08 i need to be able to use the numbers 1 - 52 again however they have different week start dates.
any ideas?