Is it possible to use parentheses in the local view designer? I have a WHERE clause that reads:
WHERE Empmaster.deptcd == ?cDept AND Empmaster.termdate =CTOD("") OR Empmaster.termdate > DATE()
I need it to read:
WHERE Empmaster.deptcd == ?cDept AND (Empmaster.termdate =CTOD("") OR Empmaster.termdate > DATE())
Alan Trosky
MIS Director
Pennsylvania Bar Association
Harrisburg PA 17108