[AccessD] select distinct per year

Pedro Janssen pedro at plex.nl
Sat Apr 19 13:38:42 CDT 2003


Hello Susan,

sorry i wasn't clear enough.
For example: TableA   has a date field and a number field.
What i need is to make calculations on alle the record for the number field for each year.

TIA

Pedro Janssen 
  ----- Original Message ----- 
  From: Susan Harkins 
  To: accessd at databaseadvisors.com 
  Sent: Saturday, April 19, 2003 6:46 PM
  Subject: Re: [AccessD] select distinct per year


  SELECT DISTINCT  fldlist|*
  FROM table
  WHERE  DatePart("yyyy",datefield) = year
   
  =======But I'm guessing that's not really what you're after -- I'm not sure I understand -- you want the results for a particular year, or you want them all, just grouped by their year?
   
  Susan H. 
    Hello Group,

    how can i make an select disctinct for all the record in a date field (dd-mm-yyyy) per year??

    TIA

    Pedro Janssen


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


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



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


  _______________________________________________
  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/20030419/3819a67c/attachment-0001.html>


More information about the AccessD mailing list