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.
Duane Hookom - 16 Aug 2005 14:54 GMT
You can use DateAdd() to add or subtract numbers of days, months, years,
seconds,... For instance:
NextReview: DateAdd("yyyy",2,[DateOfLastReview])

Signature
Duane Hookom
MS Access MVP
--
> 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
[quoted text clipped - 7 lines]
> days past the due date base on the last review date. If you can help or
> inform, I would appreciate it.