Apply many filters

[fathyano]

I have a database for a law firm, recording all the details of the cases, including dates. One of the most important detail of the case is the dates.

First lets have a very simple idea about the dates;

When some one wins a case, he files an Enforcement Case in order to be able to enforce the judgment rendered for his favor, but the other losing party may appeal the case after the winning party starts enforcing the judgment, in this case the enforcement case does not stop the normal case, so the result will be two cases parallel to each other (not subsequent).

In my database I have made buttons for displaying all the cases of which the next hearing shall take place on specific month, for intance a button called January, when I press this button the action will be to open the form, at the same time applying the query of the month.

But the problem is that we have two (next date); first is (date of the next hearing) while the other is (date f next hearing for the enforcement case).

I have made the query to display only case took place in Jan, but for the normal case, not the enforcement one.

Now I want to make a query, or amend the existing one, selecting any case of which ANY of the two (next hearing date) is on Jan.

I want to tell the query of jan: - display all the cases of which have hearing in jan (even if the other date falls in another month), and so on... (i.e: the cases of which the [next hearing] in Jan or the [next enforcement hearing] is in jan, or both of them in jan)

Attached is a simple sample of my data base,

Your fast reply is toooooo much appreciated

Thank you

 

[Galaxiom]

In design view of the query just add the extra conditions on separate lines. This will give all records with any one of the conditions met.

For comparison: When you place them all on the same line, all conditions must be met for a record to display.