General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only