Tying to pull only dates between two given dates

[sellis]

I am trying to only pull records that are between 04/01/2011 and 05/31/2011. I have access 2007, and here is my current code.

Days Worked: IIf([Emp Date]![Term Date]>#4/1/2011# Or [Emp Date]![Term Date]<#5/31/2011#,IIf([Emp Date]![Rehire Date] Is Not Null,DateDiff("d",[Emp Date]![Rehire Date],"5/31/2011"),DateDiff("d",[Emp Date]![Hire Date],"05/31/2011")),Null)

I have been testing and adding slowly, and everything worked until I added the extra part to pull anything greater than 04/01/2011. Any ideas how to fix this would be great. The resoluts no longer separate anything at all and at least it used to pull only the stuff before 05/31. Thanks

 

[Norie]

You seem to be doing a little more than pulling records between 2 dates.

If that's all you wanted to do you could use this.

[Emp Date] Between #4/01/2011# And #05/31/2011#

By the way your logic isn't quite right for the first part, it should be And not Or.

With Or you will be pulling all records after 4/01/2011 and all records before 05/31/2011.

That's basically all records.

 

[sellis]

Thanks - the And/Or was the problem.