[AccessD] total of sum

Pedro,
 
Try this:
 
SELECT Diag, Sum(Number) AS Total
FROM [YourTable]
GROUP BY Diag
 
Paul Hartland






Message date : Mar 25 2004, 12:45 PM
>From : pedro at plex.nl
To : accessD at databaseadvisors.com
Copy to : 
Subject : [AccessD] total of sum
Hello group,

i need to make an presentation of some figures for later this afternoon. I had a query that made a sum of numbers as a total, but i can't find it right now. Can You give me a hand?

i have

diag number
biopt 5
biopt 7
biopt 2
ascites 4
ascites 6


i need

diag Total
biopt 14
ascites 10

Thanks

Pedro Janssen


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime