<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2920.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Thanks for your help Juan. </FONT></DIV>
<DIV><FONT face=Arial size=2>This is an usefull function. Never noticed
that is was present. But it gives me only the Top 5 of the total of
records.</FONT></DIV>
<DIV><FONT face=Arial size=2>I tried to give me the top5 dates each year with
this function, but i can't make it work</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Drew, i don't have a criterium for the records i
don't want to. I just need the first 5 each year.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Pedro</FONT></DIV>
<BLOCKQUOTE dir=ltr
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A href="mailto:mastercafe@ctv.es" title=mastercafe@ctv.es>MastercafeCTV</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
href="mailto:accessd@databaseadvisors.com"
title=accessd@databaseadvisors.com>accessd@databaseadvisors.com</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, March 05, 2003 12:30
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] first five dates
per year</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=080472023-04032003><FONT color=#0000ff face=Arial 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 color=#0000ff face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=080472023-04032003><FONT color=#0000ff face=Arial size=2>Juan
Menendez</FONT></SPAN></DIV>
<DIV><SPAN class=080472023-04032003><FONT color=#0000ff face=Arial
size=2>Mastercafe SL</FONT></SPAN></DIV>
<DIV><SPAN class=080472023-04032003><FONT color=#0000ff face=Arial size=2><A
href="http://www.mastercafe.com">www.mastercafe.com</A></FONT></SPAN></DIV>
<DIV><SPAN class=080472023-04032003><FONT color=#0000ff face=Arial
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
size=2>-----Mensaje original-----<BR><B>De:</B> <A
href="mailto:accessd-admin@databaseadvisors.com">accessd-admin@databaseadvisors.com</A>
[<A
href="mailto:accessd-admin@databaseadvisors.com">mailto:accessd-admin@databaseadvisors.com</A>]<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></BLOCKQUOTE></BODY></HTML>