Ken,
Whoops.. Lost the first line...
SELECT Tasks.taskid, Tasks.who, Tasks.custno, Tasks.tasktrak, Tasks.date, ;
DATE()-DATE AS numdays, completedt ;
FROM Tasks ;
WHERE ALLTRIM(UPPER(tasks.tasktrak)) == "FILEREVIEW" AND ;
ALLTRIM(UPPER(who)) == "MATT" AND ;
tasks.custno IN (SELECT tasks.custno FROM tasks WHERE ALLTRIM(upper(tasks.tasktrak)) == "PROCCOMP" AND ;
EMPTY(tasks.completedt) = .T.)
Best,
DD
A man is no fool who gives up that which he cannot keep for that which he cannot lose.
Everything I don't understand must be easy!
The difficulty of any task is measured by the capacity of the agent performing the work.