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

On 18 Dec 2006 18:51:00 -0800, kunal0101@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