View Full Version : Date


Acenmbr1
02-03-2008, 09:41 AM
Hey heya all. Just joined the forums. Been browsing and seems like a lot of helpful people. I am just a novice, so I am sure that this forum will come in extremely handy.

How do I make a date dependent on a separate date and have it auto-enter?

I have one table that lists all personnel, the date training was completed and the DUE date for thier next training. I would like to have it so that when the training complete date is change, the training DUE date automatically changes based on the frequency for that training.

Thanks in advance.

Rich
02-03-2008, 09:48 AM
Your question is the main reason that DueDate should not be stored but calculated. Look up queries and the DateAdd function

Acenmbr1
02-03-2008, 09:56 AM
Perfect. Thanks Rich. Will look it up.