<!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.1126" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=143121605-24042003><FONT face=Arial color=#0000ff
size=2>Pedro,</FONT></SPAN></DIV>
<DIV><SPAN class=143121605-24042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=143121605-24042003><FONT face=Arial color=#0000ff size=2>Will
this do what you are asking?</FONT></SPAN></DIV>
<DIV><SPAN class=143121605-24042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=143121605-24042003><FONT face=Arial color=#0000ff size=2>SELECT
Table2.TestDate2<BR>FROM Table1, Table2<BR>WHERE
(((Table1.TestDate1)=#5/15/2003#) AND
((Table2.TestDate2)>=DateAdd("d",-10,#5/15/2003#) And
(Table2.TestDate2)<=#5/15/2003#));</FONT></SPAN></DIV>
<DIV><SPAN class=143121605-24042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=143121605-24042003><FONT face=Arial color=#0000ff size=2>I've
taken both tables and added them to a query but they are not joined. I set
the criteria for TestDate1 in Table1 to equal 5/15/2003 and the criteria for
TestDate2 in Table2 >= 10 days before 5/15/2003 (which is 5/5/2003) and <=
5/15/2003.</FONT></SPAN></DIV>
<DIV><SPAN class=143121605-24042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=143121605-24042003><FONT face=Arial color=#0000ff size=2>This
give me all dates between 5/5/2003 and 5/15/2003</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><B><I><FONT face="Times New Roman" color=#0000ff size=4>John V.
Ruff</FONT><FONT face="Times New Roman" color=#008080 size=4> – The Eternal
Optimist</FONT><FONT face="Times New Roman" size=4></FONT> <FONT face=Wingdings
color=#800080 size=4>J</FONT></I></B><I></I> <BR><I><FONT
face="Times New Roman">Always Looking For Contract Opportunities</FONT></I> </P>
<P><FONT face="Times New Roman" size=2>Home: 253.588.2139</FONT> <BR><FONT
face="Times New Roman" size=2>Cell: 253.307/2947</FONT> <BR><FONT
face="Times New Roman" size=2>9306 Farwest Dr SW</FONT> <BR><FONT
face="Times New Roman" size=2>Lakewood, WA 98498</FONT> </P>
<P><B><I><FONT face="Times New Roman" color=#000080 size=2>“Commit to the Lord
whatever you do,</FONT></I></B> <BR><B><I><FONT face="Times New Roman"
color=#000080
size=2>
and your plans will succeed.” Proverbs 16:3</FONT></I></B><I></I> </P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----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> Tuesday, April 22, 2003 4:08 AM<BR><B>To:</B>
AccessD@databaseadvisors.com<BR><B>Subject:</B> [AccessD] 10 days
before<BR><BR></FONT></DIV>
<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>