[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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030419/8e0dc4dd/attachment-0001.html>