>
>BUt I can say with even more certainty that you
>are doinng
>right by changing the GROUP BYs to WHEREs.
>
>Tom
>

Thanks for the re-assurance. I have replace all of my HAVINGs
with WHERE equivalents. I don't think U meant GROUP BY.
Anyhow, I hope everyone is aware of this VFP SQL weakness...

And watch out for those MRIs, I've heard of people entering
those big iron lungs and never returning... Hope U are hearing
better soon. Steve