One Parameter for Multiple Fields

[LadyDi]

Is there a way to have one parameter in a query effect multiple fields?

I have a table that details service calls on our equipment. There are columns in that table for each part of the equipment that get marked, depending on what needed serviced (i.e. software, printer, keypad, monitor, etc). I would like to be able to run a query that will show all the service calls where one part of the equipment was serviced multiple times without have to enter multiple parameters or write a union query (there would need to be 11 unions or 11 parameters for each part to be captured). For example, I would want to know how many pieces of equipment had 3 or more service calls on their software. I want to run the query without having to say that I don't care how many service calls were performed on the printer, monitor, or keypad. I would like to be able to say "Software >3" and have the query run on that information. Is that possible?

 

[Pat Hartman]

Create a query that joins the equipment table to the service table. Select the equipmentID from the equipment table and the serviceType from the service table to group by and add a count expression to count the services. Add your criteria to the count column.