A2003 - Getting records between two dates

[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

 

[KARL DEWEY]

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

 

[drunkjunkie via AccessMonster.com]

Works a treat, thanks for your help.

J

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

Hi,

[quoted text clipped - 7 lines]

Jon