Hi Donald,
>The problem I've got with this particular string is the last "and" clause. I keep getting syntax errors.
Sometimes VFP has problems if you insert a line break into a string. Use something like
Query = "....."+;
"......"+;
"......"
instead.
Christof
--
Christof