Select data between two dates

[Guest]

I have an employee database with FName, LName, Start_Date.
I need to be able to choose two dates and select all people who fall between
these days within working 30/60/90/270/450 days since there start date.

For example, I want to see anyone who has been working for us for
30/60/90/270/450 days between the week of 6/13/05 - 6/27/05. So from the day
they started we can get the number of days to the end date ^ to see how many
days they have been with us using the
DateDiff("d",[Start_Date],#6/27/2005#) function

 

[Guest]

Use the following criteria in your select query --
Between [Enter first date] and [Enter end date]