How do I setup calculations for dates and overdues dates in acces

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having trouble with my database. I need to be able to put expressions
into my database. I have 4 columns that are applicable. DOE-Date of
employment, Date of last review, next review due, and days late. I want to be
able to input the Date of employment by hand. I want the date of last review
to be done by hand also. I want date of next review to calculate 2 years from
the date of last review. I also want days late to calculate the number of
days past the due date base on the last review date. If you can help or
inform, I would appreciate it.
 
You can use DateAdd() to add or subtract numbers of days, months, years,
seconds,... For instance:
NextReview: DateAdd("yyyy",2,[DateOfLastReview])
 
Back
Top