how do I find employees between 06/10/2006 and 12/31/2006

[Guest]

I am attempting to do a query to gather all the employees who left employment
beginning 06/01/2006 and through 12/31/2006. I have put the expression
between 06/01/2006 and 12/31/2006, but it brings up everyone from day one's
last day

 

[Smartin]

I am attempting to do a query to gather all the employees who left employment
beginning 06/01/2006 and through 12/31/2006. I have put the expression
between 06/01/2006 and 12/31/2006, but it brings up everyone from day one's
last day

Hi Robin,

First, check that your "date left employment" field is formatted as a
date/time type.

Second, the way to specify date/time expressions in Access is to
surround the value(s) with #, e.g.,

Between #06/01/2006# and #12/31/2006#

However, had you entered your expression without the #, and Access did
not add them automagically, I question whether the field is in fact a
date/time type.

HTH