<!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>Hi Susan,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>i thought this could be done with a select
distinct, but i wasn't sure</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>This what i have</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>TableA</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial
size=2>Date
num1
num2</FONT></DIV>
<DIV><FONT face=Arial
size=2>01-02-2000 5,2 4,1</FONT></DIV>
<DIV><FONT face=Arial
size=2>02-03-2000
4,6
4,3</FONT></DIV>
<DIV><FONT face=Arial
size=2>01-04-2001
4,2
6,5</FONT></DIV>
<DIV><FONT face=Arial
size=2>14-07-2001
6,2
3,1</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>This is what i want;</FONT></DIV>
<DIV><FONT face=Arial size=2>in this example the calculation is sum</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial
size=2>Date
num1
num2</FONT></DIV>
<DIV><FONT face=Arial
size=2>2000
9,8 8,4</FONT></DIV>
<DIV><FONT face=Arial
size=2>2001 10,4
9,6</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Pedro Janssen</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE
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:harkins@iglou.com" title=harkins@iglou.com>Susan Harkins</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> Saturday, April 19, 2003 11:01
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] select distinct
per year</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>But you want only unique records based on both
the record and the date field? I don't understand how DISTINCT fits in.
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Susan H. </FONT></DIV>
<BLOCKQUOTE
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:pedro@plex.nl" title=pedro@plex.nl>Pedro Janssen</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> Saturday, April 19, 2003 2:38
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] select distinct
per year</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Hello Susan,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>sorry i wasn't clear enough.</FONT></DIV>
<DIV><FONT face=Arial size=2>For example: TableA has a date
field and a number field.</FONT></DIV>
<DIV><FONT face=Arial size=2>What i need is to make calculations on alle the
record for the number field for each year.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>TIA</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Pedro Janssen</FONT> </DIV>
<BLOCKQUOTE
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:harkins@iglou.com" title=harkins@iglou.com>Susan
Harkins</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> Saturday, April 19, 2003 6:46
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [AccessD] select
distinct per year</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>SELECT DISTINCT fldlist|*<BR>FROM
table<BR>WHERE DatePart("yyyy",datefield) = year</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>=======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?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Susan H. </FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV><FONT face=Arial size=2>Hello Group,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>how can i make an select disctinct for all
the record in a date field (dd-mm-yyyy) per year??</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>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD
mailing list<BR><A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>