A2003 - Getting records between two dates

  • Thread starter drunkjunkie via AccessMonster.com
  • Start date
D

drunkjunkie via AccessMonster.com

Hi,

I have a table with two columns each containg a start date and an end date
(tblHHExport). I also have a second table with a list of dates in (tblDates).

What I need to do is for each record in tblHHExport extract all records from
tblDates where the date is between the start and end date in tblHHExport.

Any help would be appreciated.

Jon
 
K

KARL DEWEY

SELECT tblDates.ListDate
FROM tblDates, tblHHExport
WHERE (((tblDates.ListDate) Between [StartDate] And [EndDate]));
 
Top