>>>WHERE Empmaster.deptcd == ?cDept AND INLIST(Empmaster.termdate, {}, DATE())
>>>
>>>or
>>>
>>>WHERE Empmaster.deptcd == ?cDept AND Empmaster.termdate IN ( {}, DATE() )
>>>
>>>The {} means empty date
>>
>>That won't work Mark... he needs Empmaster.termdate > DATE()
>
>I caught that right after posting, and posted a supplemental reply to that affect.
OK... but you forwarded the first email to me and not the supplemental... I only replied because you had sent the email to me.
Brien R. Givens
Brampwood Systems