Access Criteria help

[Kasturi]

I have a query that I created in MS Access and was needing a little help.

I am wanting to pull data that is between certain dates.
For example all items entered between 9-1-10 & 9-30-10
I got that part figured out pretty well. I get my pop up box to enter my date ranges in.

However I also want to be able to pull information if a payment was recovered between those dates or if a payment was stopped between those dates.
Here's what I have in my criteria:

Field: Recovery Date - Criteria: Between [Start Date mm/dd/yyyy] And [End Date mm/dd/yyyy]

Field: Date Recovered - Criteria (or): Between [Start Date mm/dd/yyyy] And [End Date mm/dd/yyyy]

Field: Date Recovery Stopped - Criteria (or): Between [Start Date mm/dd/yyyy] And [End Date mm/dd/yyyy]


I can get it to pull the required info if I remove one of the (or) cirteria. For example I can get all of the items entered between 9-1-10 & 9-30-10 as well as items that were recovered between 9-1-10 & 9-30-10. I cannont however get it to pull the information if the payment was stopped between those dates.

If I take out the Date Recovered (or) criteria and leave in the Date Recovery Stopped field then I can get that data.


Is there a limit to the (or) criterias that can be used or am I just not setting it up correctly.

I was trying to stay away from VB code if possible.