I guess that you have created a program where you open the table
then
Sum mytable.field1 to xx
is another Foxpro Sentence.
Try opening your table in the command comm window and write this instruction o insert it into your code
Juan C
"Anyone who has never made a mistake has never tried anything new." A.E
"The important thing is not to stop questioning. Curiosity has its own reason for existing." A.E