By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 1,710 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

urgent help required: need to auto update date field

P: n/a
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

Dec 19 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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
Dec 19 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.