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.

 

[Trevor G]

Brian,

Can you upload a smaple of your database with a little data in.

In the table design where you are holding the dates is the format like this:

mm/dd/yyyy or dd/mm/yyyy

 

[Brian62]

Got it figured out. Thanks!