date due calculation

  • Thread starter Thread starter lynn atkinson
  • Start date Start date
L

lynn atkinson

I have a field which calculates and displays when a
refresher course is due based on qualification duration
field. However, some courses never expire and do not need
to be refreshed. How do I deal with this? At the moment, I
am putting in a large number of months such as 1000 months
so the date due is about the year 3000 and therefore is
not flagged as being due soon.
My calculation at present is as follows:

calc date due: Max((DateAdd("m",[course details]!
[qualification duration],[event schedule]![eventdate])))

ie add the qualification duration on to the event date to
give the date due.
If a number of refresher courses have been attended, only
the last one is displayed.

If there is no qualification duration ie the course only
needs to be done once, how do I address this.

thanks in advance
 
You can use an IIf statement in the calculation:

IIf([qualification duration] Is
Null,WhateverYouWantToSee,Max((DateAdd("m",[course
details]!
[qualification duration],[event schedule]![eventdate]))))
 
Bob said:
You can use an IIf statement in the calculation:

IIf([qualification duration] Is
Null,WhateverYouWantToSee,Max((DateAdd("m",[course
details]!
[qualification duration],[event schedule]![eventdate]))))
Click to expand...
This will work but qualification duration should never be allowed to be
Null
I would add a qualification required field and make it boleen cxxcx
 
Mike said:
Bob said:
You can use an IIf statement in the calculation:

IIf([qualification duration] Is
Null,WhateverYouWantToSee,Max((DateAdd("m",[course
details]!
[qualification duration],[event schedule]![eventdate]))))
Click to expand...
This will work but qualification duration should never be allowed to
be Null
I would add a qualification required field and make it boleen cxxcx
Click to expand...

Let's try that again. I would make it boolean (forget the cxxcx) and build a
query on that.
A date would be allowed to remain null only if the qualification required
field was no.
 
Back
Top