[AccessD] 10 days before

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.
 
A.
 
 -----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pedro Janssen
Sent: April 22, 2003 7:08 AM
To: AccessD at databaseadvisors.com
Subject: [AccessD] 10 days before



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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030422/7fd56163/attachment-0001.html>