totalling non-unique records

[Guest]

Looks like this now;
Joe 12
Joe 10
Joe 14
Jim 9
Jim 8
Jack 10
Jack 11
Jack 14

I need it to look like this;
Joe 36
Jim 17
Jack 35

Any ideas?

Thanks

 

[Mastercafe - Juan]

Make the recordsource with this

SELECT StName, Sum(InValue) AS SumOfValue
FROM YourTable
GROUP BY StName;

--
Saludos

Juan
Mastercafe S.L.
www.mastercafe.com
(e-mail address removed)