I have a simple payroll table with multiple entries for each employee. Something like;

Empno empname gross
1 jack $500
1 jack $500
2 Jill $100
2 Jill $100
2 Jill $100

etc...

I'd like to create a table like this;
Empno empname gross
1 jack $1000
2 jill $300

where the gross has been summed for each employee.

In the past I have done this with scan/endscan and calculate sum , old method.

Can someone show me an example of a simpler method, I suspect SQL select.

Thanks, I apologize for being so elementary but my vfp usage has been almost nihl for the past year.

Steve