[AccessD] first five dates per year

Tue Mar 4 17:34:12 CST 2003

Yes simply use TOP 5 clausule in SQL Query , check SQL help in A2k the
command TOP and BOTTOM for the first or last in a query

Juan Menendez
Mastercafe SL
www.mastercafe.com

  -----Mensaje original-----
  De: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]En nombre de Pedro Janssen
  Enviado el: martes, 04 de marzo de 2003 23:14
  Para: AccessD at databaseadvisors.com
  Asunto: [AccessD] first five dates per year

  Hello Group,

  i have a table with 10000 records. I would like to filter out, by query,
the first 5 or 10 dates per different years.
  Is this possible.

  TIA

  Pedro Janssen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030304/d7386d6a/attachment-0001.html>