[AccessD] total of sum

Hi Pedro,

In your query, you want to Group By on the first field and then Sum the 
second field.

Ryan






pedro at plex.nl
Sent by: accessd-bounces at databaseadvisors.com
25/03/2004 13:44
Please respond to Access Developers discussion and problem solving 

 
        To:     accessD at databaseadvisors.com
        cc: 
        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



 

  
This e-mail and any attachment are confidential and contain proprietary information, some or all of which may be legally privileged.  It is intended solely for the use of the individual or entity to which it is addressed.  If you are not the intended recipient, please notify the author immediately by telephone or by replying to this e-mail, and then delete all copies of the e-mail on your system.  If you are not the intended recipient, you must not use, disclose, distribute, copy, print or rely on this e-mail.

Whilst we have taken reasonable precautions to ensure that this e-mail and any attachment has been checked for viruses, we cannot guarantee that they are virus free and we cannot accept liability for any damage sustained as a result of software viruses.  We would advise that you carry out your own virus checks, especially before opening an attachment.

The UK firm Ernst & Young LLP is a limited liability partnership registered in England and Wales with registered number OC300001 and is a member practice of Ernst & Young Global.  A list of members? names is available for inspection at 1 More London Place, London, SE1 2AF, the firm?s principal place of business and its registered office.