DateAdd in Table 1

[USCG]

I Have three fields, Date_Completed, Cycle, and Date_Due which I would like to use in a maintenance database to forcast when a completed task will be next due.

Date_Completed = Shortdate
Cycle = How often this task is completed in days.
Date-Due - to be calculated by the databse.


I would like the Date_Due field calculated after the Date_Completed and Cycle are entered. Can this be done directly in the table?

David

 

[dhookom]

It can't be done in the table and it should not be done. If you need the Date_Due, you can always calculate it in a query or expression in a control source.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.