HI, Thanks in advance,
How do I write a formula that returns a "Current" or "Overdue" based on a field that tells how many days that task has to be performed and it has a Max activity date summary field, and a "Activities Due Every (x) Days" field.
Today()-[Max Activity Date]>([Activities Due Every (x) Days]),"Current","Activities Due"))
That was the best I could figure out. Thanks again
------------------------------
Bob Faulk
------------------------------