>Hi Mo,
>
>I get a "general" SQL compile error, in that SQL doesn't understand the code. I did work around my immediate problem by breaking my SQL statements into three seperate expressions.
>
>However, I guess my question is can you combine more than one "sum" statement within a SQL expression. I.e. "Select all from Sample, sum for x,+ sum for y + sum for z, etc..
>
>Any ideas?

Hi Donald

I just tested the SQL as you said without any problem,

Select *, sum(x)+sum(y) from table ....

I am using vfp5.
It could be different problem

Mo