It's basic select with SUM() and GROUP BY
SELECT Empno, empname, SUM(gross) As Amount FROM mytable GROUP BY Empno, empname
>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
--sb--