Criteria issue for limiting a query

I have built a query1 that allows me to enter a date range for when an issue
is opened. I then built another query2 off of that one using these criteria:

[Please Enter Prior Date] and [Please Enter Post Date]

My goal is to have this query return all issues opened before the date range
I specify in query1 and that did not close before the end of that date range.
It does work except that will only return the items that have a closed date.
It won't capture the ones that remain open and do not have a close date. What
can I do to modify this criteria: [Please Enter Post Date] under the closed
date so that it returns everything I need?

Try this --
[Please Enter Prior Date] and [Please Enter Post Date] OR Is Null

I prefer using --
Between [Please Enter Prior Date] and [Please Enter Post Date] OR Is Null
as it includes the date entered also when they do not have time associated
with them.
--
KARL DEWEY
Build a little - Test a little


"Antavas" wrote:

I have built a query1 that allows me to enter a date range for when an issue
is opened. I then built another query2 off of that one using these criteria:

[Please Enter Prior Date] and [Please Enter Post Date]

My goal is to have this query return all issues opened before the date range
I specify in query1 and that did not close before the end of that date range.
It does work except that will only return the items that have a closed date.
It won't capture the ones that remain open and do not have a close date. What
can I do to modify this criteria: [Please Enter Post Date] under the closed
date so that it returns everything I need?

Thanks! It worked!

"KARL DEWEY" wrote:

Try this --
[Please Enter Prior Date] and [Please Enter Post Date] OR Is Null

I prefer using --
Between [Please Enter Prior Date] and [Please Enter Post Date] OR Is Null
as it includes the date entered also when they do not have time associated
with them.
--
KARL DEWEY
Build a little - Test a little


"Antavas" wrote:

I have built a query1 that allows me to enter a date range for when an issue
is opened. I then built another query2 off of that one using these criteria:

[Please Enter Prior Date] and [Please Enter Post Date]

My goal is to have this query return all issues opened before the date range
I specify in query1 and that did not close before the end of that date range.
It does work except that will only return the items that have a closed date.
It won't capture the ones that remain open and do not have a close date. What
can I do to modify this criteria: [Please Enter Post Date] under the closed
date so that it returns everything I need?