[AccessD] 10 days before

Ron,

although i have another solution, 
i am still interested in letting your query work.
But it isn't. I get as result only the name without any results.
I don't understand why. Do you??

Pedro Janssen


----- Original Message ----- 
From: "Ron Allen" <chizotz at charter.net>
To: <accessd at databaseadvisors.com>
Sent: Tuesday, April 22, 2003 8:46 PM
Subject: Re: [AccessD] 10 days before


> Pedro,
> 
> You could try something similar to this:
> 
> SELECT TableB.DateB
> FROM TableB, TableA
> WHERE (((TableB.DateB) Between [TableA]![DateA]-10 And 
> [TableA]![DateA] 
> AND [TableA]![DateA]=#4/20/2003#));
> 
> If you need to restrict the dates selected form TableA, 
> you can do that in the last line.
> 
> HTH,
> 
> Ron
> 
>   
> 
> On Tue, 22 Apr 2003 13:07:42 +0200
>   "Pedro Janssen" <pedro at plex.nl> wrote:
> >Hello Group,
> >
> >i have two tables
> >Tablea has 1 field with dates (1 date per year)
> >and TableB has 1 date field (1 record per date from all 
> >dates between 1950 and 2002) and 10 number fields.
> >
> >What i need is from all the dates that are present in 
> >TableA, all the records from TableB for 10 days back.
> >
> >TIA
> >
> >Pedro Janssen
> 
> <TEXTAREA NAME="Signature" ROWS="4" COLS="60">
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>