Filtering a Query with One Criteria over Multiple Fields

[Grave]

Hi,

I have a database that tracks various inspection due dates on industrial support equipment. Each piece of equipment has several different inspection cycles (180-day, 365-day, 720-day, etc). Basically what I'm trying to create is a report that will show equipment that is due any of their inspections, that fall under a user-defined date range.



For example, my query looks something like this:

EQUIPMENT ID	180-DAY INSPECTION	365-DAY INSPECTION	720-DAY INSPECTION
G1137	29-DEC-12	25-JAN-13	15-JAN-14
G1140	29-DEC-12	27-OCT-12	04-SEP-12
G1141	08-AUG-12	21-AUG-12	09-AUG-12

What I want to do is have the user click on a button to open up a new form. Then, the user will enter in a START DATE and END DATE, and click another button to initiate the query. What I want the query to do is look at ALL the different inspections, and if ANY of the inspection dates for that particular piece of equipment falls within the specified date range, I want that particular piece of equipment (along with all it's inspection dates) to display.

I can get the query set up to do this for one Field at a time, but not multiple ones simultaneously. Any help would be greatly appreciated!

[pbaldy]

Add the same criteria to all the fields, but each on a different line. In SQL view, that makes it OR instead of AND.

[June7]

Did you try OR operator? The criteria goes under each field, but on different Criteria lines in the query design grid. Criteria: BETWEEN Forms!formname!StartDate AND Forms!formname!EndDate.

[Grave]

Add the same criteria to all the fields, but each on a different line. In SQL view, that makes it OR instead of AND.

That did the trick, thanks!

Did you try OR operator? The criteria goes under each field, but on different Criteria lines in the query design grid. Criteria: BETWEEN Forms!formname!StartDate AND Forms!formname!EndDate.

I did try the OR operator, however, what I did wrong was put the same criteria on the same line all the way across. Putting them on a different OR line did the trick.

[pbaldy]

No problemo!

[Grave]

Ok, now for Step #2 for my report:

They way I currently have it set up: The user clicks a button, and it opens up a form. The form has a START DATE and END DATE text field. Once the user inputs the date range, they click a "submit" button, and that takes them right to the query. How do I get this into a report format? What I want to do is have the user select their date range, and when they hit the "submit" button, it generates a report based off the results shown in the query.

When I try and create a report using the query directly, a "enter parameter value" popup shows up.

** EDIT **

Disregard... I figured it out. I need to take a break now, lol!