[AccessD] select distinct per year

MessageThanks to all who helped with this sql.

Pedro Janssen
  ----- Original Message ----- 
  From: Arthur Fuller 
  To: accessd at databaseadvisors.com 
  Sent: Monday, April 21, 2003 1:44 PM
  Subject: RE: [AccessD] select distinct per year


  In SQL the query is:
   
  select datepart(yyyy,dateentered), sum(num1), sum(num2)
  from TableA
  group by datepart(yyyy,dateentered)
   
  In Access, substitute the year() function for datepart().
   
  Arthur
    -----Original Message-----
    From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pedro Janssen
    Sent: April 21, 2003 6:51 AM
    To: accessd at databaseadvisors.com
    Subject: Re: [AccessD] select distinct per year


    Hi Susan,
     
    i thought this could be done with a select distinct, but i wasn't sure
     
    This what i have
     
    TableA
     
    Date                           num1            num2
    01-02-2000               5,2                   4,1
    02-03-2000               4,6                   4,3
    01-04-2001               4,2                   6,5
    14-07-2001               6,2                   3,1
     
     
    This is what i want;
    in this example the calculation is sum
     
    Date                          num1              num2
    2000                          9,8                    8,4
    2001                          10,4                  9,6
     
    Pedro Janssen
     



------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030422/9ab5b860/attachment-0001.html>