>I get an error that "...count is invalid..." etc...it might be a syntax error, but there is an extra ";" that appears in the line when exectuted that's not there before. Here it is:
>

<snip>

Renoir,

I would remove columns one by one from the select to find out wich one is causing an error.
BTW, what's VFP version?