I am currently working on a access database for a bakery. The problem i am facing is that there is a bunch of regular weekly orders. i need to be able to on a daily basis update these dates to add a week on automaticly in the background.
For example, an order that was for yesterday with the date of 08/08/2011 now should read 15/08/2011.
Can anyone please help with either a SQL statement or VBA, either way im sure theres a solution.