Discussion Locked
Access 2000 Question
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have been trying for some time now but failed. My problem - I have ten dates seperated by a specific number of days. The first date is the date a project is started. Second date is seven days later, third is 3 days later, fourth 8 days later, fifth is 17 days later, and so on. I can do this with DateAdd and factor out the 60 day timeline. My problem is a secondary timeline that begins on the same date, factors out the 60 day time line but allows me to enter a new date in any of the ten specific point, keep the dates the same in the past and refactor the dates in the future. Please help.