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

R

RicoDorsey

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.
 
D

Duane Hookom

You can use DateAdd() to add or subtract numbers of days, months, years,
seconds,... For instance:
NextReview: DateAdd("yyyy",2,[DateOfLastReview])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top