Create a Query for Yes field and Between Dates field

[Brian62]

I have a query that I am trying to pull information from a yes/no field that is for open studies and a date field. The date field is for studies that have closed.



I need to capture all current open studies and all past closed studies that were closed during a specific time frame.

Is there a way for me to get the two to work?

[TheShabz]

It all depends on how you define what is "open" and whatnot. Just something simple given from what you described would be using the following WHERE clause

WHERE yes/nofield = yes and datefield BETWEEN #date# AND #date#
or yes/nofield = no and datefield BETWEEN #date# AND #date#

[Brian62]

I tried your solution and it comes up with no records.
I have to capture what is open which will be yes (yes/no check box= unchecked) and what closures there were during any period of time for instance between 06/01/09 and 05/31/10.

I have to capture both to show on one report versus 2 that I have now through the query.

Activestudy
Where
=yes

Closure
Where
Between #6/1/2009# And #4/26/2010#

Also tried

Between [Enter Start Date Like: 01/01/09] And [Enter End Date Like: 12/31/09]
(Which I prefer to use)

I hope this helps.

[Brian62]

This was the fix I received from another forum. This worked for me with a little tweak.

In the criteria of the date field you should just need:

(Between [Enter Start Date Like: 01/01/09] And [Enter End Date Like: 12/31/09]) or is null