Thread: Updating rotating dates
08-19-04, 08:46 #1Registered User
- Join Date
- Aug 2004
Unanswered: Updating rotating dates
I am using MS Access 2002.
I am creating a database with tables something like this.
I created the table:
I created the query and added the next_training_date by adding DateAdd("m",6,[last_training_date]).
emp_initials last_training_date next_training_date
qv 06/18/04 12/18/04
rv 08/25/04 02/25/05
What I need to happen is that every time I enter a knew last training date it becomes the new next-training-date and drops or appears to drop the old date on the form I am going to create for the users to see. Using the "qryemployees" example above for emp_initials "qv", a user enters for "qv" the date which in this case was earlier instead of waiting until 12/18/04 the training was done on 12/04/04 so the new next_training_date is 06/04/05, so I need 12/18/04 to be dropped from view, but still would be available as to prove the training was done. Of course there will be other columns but the trainining_date columns would be constantly rotating by adding 6 months to the last training_date. I hope I have made my self clear. Can someone help me?
08-19-04, 11:34 #2Cavalier King Charles
- Join Date
- Dec 2002
- Préverenges, Switzerland
try a table that hold initials and training date (NOT last training date)
from there, you can query up a list of employees and most recent training dates (hit the sigma in the query design window, group by initials, max the date)
...from there, your dateadd is +6 on the most recent training date gives you the next training date, and all trainings are saved until your disk crashes.
(i don't like initials... why not an autonumber primary key on a decent table of employee names - just in case you end up with Felicity Smith & Fred Spatula as employees)currently using SS 2008R2