You either have one too many ending brackets or you're missing a starting bracket. Also, I'm not sure if LOCATE returns a value...
>help!
>what am I doing wrong here. It returns an error saying is missing a comma.
>Can I use the LOCATE here?
>
>IIF(LOCATE FOR temp.Fyr = '2002' AND temp.source '777'),temp.descr," ")
Ronald Suen
Epic Information Solutions Inc.
Ph: (780) 488-4418
Fax: (780) 488-0402