<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=080472023-04032003><FONT face=Arial color=#0000ff size=2>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</FONT></SPAN></DIV>
<DIV><SPAN class=080472023-04032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=080472023-04032003><FONT face=Arial color=#0000ff size=2>Juan
Menendez</FONT></SPAN></DIV>
<DIV><SPAN class=080472023-04032003><FONT face=Arial color=#0000ff
size=2>Mastercafe SL</FONT></SPAN></DIV>
<DIV><SPAN class=080472023-04032003><FONT face=Arial color=#0000ff size=2><A
href="http://www.mastercafe.com">www.mastercafe.com</A></FONT></SPAN></DIV>
<DIV><SPAN class=080472023-04032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Mensaje original-----<BR><B>De:</B>
accessd-admin@databaseadvisors.com
[mailto:accessd-admin@databaseadvisors.com]<B>En nombre de </B>Pedro
Janssen<BR><B>Enviado el:</B> martes, 04 de marzo de 2003
23:14<BR><B>Para:</B> AccessD@databaseadvisors.com<BR><B>Asunto:</B> [AccessD]
first five dates per year<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Hello Group,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>i have a table with 10000 records. I would like
to filter out, by query, the first 5 or 10 dates per different
years.</FONT></DIV>
<DIV><FONT face=Arial size=2>Is this possible.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>TIA </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Pedro
Janssen</FONT></DIV></BLOCKQUOTE></BODY></HTML>