Formula's to show a next calculated date in a record

  • Thread starter Thread starter Kath via AccessMonster.com
  • Start date Start date
K

Kath via AccessMonster.com

Hi there,
I am trying to work on an evaluation tracking process within MS Access. I
need to be able to automatically, based on the last 6 month evaluation,
read that record (once a check box was clicked indicating the evaluation
took place) to automatically formulate the next evaluation date by rolling
it forward 365.25 days. (Every year they get an annual eval, then mid way
through the year there is a 6 month evaluation.) How is this best
accomplished?

I presently have an annualeval table and a 6month eval table. I have these
as subforms in datasheet mode, when the user would click the checkbox, on
change event would then create a new record, adding 365.25 days to the last
record for that employee. I had been using the
nz((dmax) but it was reading the "last record" in the table, not related to
that employee.

Any help would be appreciated. FYI: I know calculations are typically in
queries, just trying to save the user some thought and typing.

Thanks!
 
Why are you adding 365.25? Just add 1 to the year.

See "DateAdd" in help for more information.

Rick B
 
I am not sure how this will work I guess. I have a datasheet, and the last
record for that employee is what I need to use for the DateAdd function.
Will it perform that on a datasheet - based on the current record?

Thanks,
Kathie
 
Back
Top