Filtering a Query

[Brian62]

I am trying to filter a query to give me this. The filters below is what I am trying but Date 2 is still pulling dates that are less than june 1, 2009.



Date1 is filtered like this: >#12/31/2007#
Between [Enter: Start Date Like 05/31/09] And [Enter: End Date Like 06/01/10]

Date2 is filtered like this: >#5/31/2009#

Date2 has some dates but not all. This date shows when a study is closed. I have to have all data but not show closed studies before June 1, 2009.

I need to show all records after Jan 1, 2008 (Date1), and include (Date2) records that are between June 1, 2009 and May 31, 2010.

I hope you can understand this.

[TheShabz]

I think this is what you want

WHERE Date1 >=#1/1/2008 And Date2 Between #6/1/2009# And #5/31/2010#

[Brian62]

Figured it out. Thanks!