Querying data between dates

[paultri]

I have a table that holds an employee hire date. What i need to do is create a query that will show all employees between a certain range of dates whether it be in the past or future date, that have been with the company for 90 days. Though i only want to show those of them that are 90 days not anything under 90 or over 90.

My desired result would be to be able to search say 09/01/03 thru 09/30/03 and have it display employees that will have their 90 day anniversary in that timeframe.

Is this possible to do? if so please help!!!!

Thanks in advance....

Paul

 

[Mile-O]

Lookup the DateAdd() function in the help files.

There are also loads of answers and examples on this forum on searching between dates.