Pedro Janssen
pedro at plex.nl
Tue Apr 22 12:44:27 CDT 2003
MessageHi Arthur,
the dates in TableA are looking the same as in TableB.
For Example: 01-02-2000 and can be anything, but are all from different years.
The dates in TableB are all dates between 01-01-1950 and 31-12-2000.
What i need is the records from TableB from the 10 days before the dates that are present in TableA.
I'll hope this explanes enough
Pedro Janssen
----- Original Message -----
From: Arthur Fuller
To: accessd at databaseadvisors.com
Sent: Tuesday, April 22, 2003 2:23 PM
Subject: RE: [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
------------------------------------------------------------------------------
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030422/258d4dab/attachment-0001.html>