<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=171352112-22042003><FONT face=Arial color=#0000ff size=2>What
exactly do the dates in TableA look like? Are they all the same day and month,
or could they be anything? There's something odd about the way this is modeled,
methinks.</FONT></SPAN></DIV>
<DIV><SPAN class=171352112-22042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=171352112-22042003><FONT face=Arial color=#0000ff
size=2>A.</FONT></SPAN></DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN class=171352112-22042003><FONT
face=Arial color=#0000ff> </FONT></SPAN></FONT></FONT></DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN
class=171352112-22042003> </SPAN>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com] <B>On Behalf Of </B>Pedro
Janssen<BR><B>Sent:</B> April 22, 2003 7:08 AM<BR><B>To:</B>
AccessD@databaseadvisors.com<BR><B>Subject:</B> [AccessD] 10 days
before<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial size=2>Hello Group,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>i have two tables</FONT></DIV>
<DIV><FONT face=Arial size=2>Tablea has 1 field with dates (1 date per
year)</FONT></DIV>
<DIV><FONT face=Arial size=2>and TableB has 1 date field (1 record per date
from all dates between 1950 and 2002) and 10 number fields.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>What i need is from all the dates that are
present in TableA, all the records from TableB for 10 days back.</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>