[AccessD] total of sum

Hi Pedro

All you need to do is make the query into a Totals query, group by diag and
sum the number.

HTH

Roz

-----Original Message-----
From: pedro at plex.nl [mailto:pedro at plex.nl] 
Sent: 25 March 2004 13:44
To: accessD at databaseadvisors.com
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