Query Creation

[kbsudhir]

Hi All,

I have Two fields of Data type in my table i.e StartDate & EndDate.
I want to create a query where the given date falls between the startdate & enddate.

Please guide.

:dunno :dunno

Thanks
Sudhir

[CreganTur]

You need to look into the Between...And operator for SQL. This will look to see if something specified falls between 2 given parameters. Access Help has good documentation.

[kbsudhir]

Thanks, I think I got it.

SELECT LeavePlanner.Name
FROM LeavePlanner
WHERE (((LeavePlanner.LeavesStartDate)<=#10/26/2008#) AND ((LeavePlanner.LeavesEndDate)>=#10/26/2008#))
GROUP BY LeavePlanner.Name;

Once again appreciating your precious time & help

Sudhir