urgent help required: need to auto update date field

[kunal0101]

Hi,

I am a new user to access and am building a database to capture the
rotation dates for employees.
There is a table called "Rotation schedule" which contains "name",
"Duration (in weeks) and "rotation date" fields. Each employee will
have many records in this table corresponding to each rotation. What i
need to do is that when a user enters the duration in weeks for a
particular MA, i need to auto calculate the next rotation date using
the below algorithm:
rotation date: Duration (in weeks) * 7 + prev rotation date

Please advise on how can i do this.
Many thanks

[Tom van Stiphout]

On 18 Dec 2006 18:51:00 -0800, ku*******@gmail.com wrote:

Check out the DateAdd function in the Help file. It is used to do date
math.

"name" is a reserved word, and not a good name for any control or
field.

-Tom.

>Hi,

I am a new user to access and am building a database to capture the
rotation dates for employees.
There is a table called "Rotation schedule" which contains "name",
"Duration (in weeks) and "rotation date" fields. Each employee will
have many records in this table corresponding to each rotation. What i
need to do is that when a user enters the duration in weeks for a
particular MA, i need to auto calculate the next rotation date using
the below algorithm:
rotation date: Duration (in weeks) * 7 + prev rotation date

Please advise on how can i do this.
Many thanks