start date with lapse days

[adar]

Hi.. Need help on the following situation
I Have fields named Start date and End date . I want to have the next start date will only be possible after 3 days the previous end date.




Appreciated your help
thanks

adar

[June7]

Previous end date for what - of all records in table, for an employee, customer? Use DMax to get the maximum date for whatever criteria is relevent then calculate the start date.

[adar]

Is actually for training recod.each employee has a start date and end date for each courses enrolled and must have a 3 days lapse before can enroll the next one. How is the formula for dmax?

[June7]

Access Help has guidelines on data aggregate functions (DSum, DCount, DAvg, DMax, DMin). General form is:

DMax("fieldname", "tablename", "criteria")

Criteria is an expression like the WHERE clause of an sql statement.