Between 2 dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 97. I've got two tables. The first table has 3 fields. Sample data as
follows

A 06/01/2005 06/07/2005
B 06/08/2005 06/15/2005
D 06/16/2005 06/23/2005

The second table has 2 fields. The first is a date. The second needs to
look-up from the first table Field #1. In essence if Table 2 has 06/03/2005
in it then I want to place an A in Field 2 of Table 2. If Table 2 has
06/08/2005 then I want to place a B in Field 2 of Table 2. Any help would be
appreciated.
 
Maybe something like the following:

SELECT Table2.SomeDate, Table1.LetterCode
FROM Table1, Table2
WHERE Table2.SomeDate Between Table1.StartDate And Table1.EndDate
 
Back
Top