[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">