I need some thoughts/suggestions.
I have a form that populates a table, monitoring Health & Safety Checks on the Facilities owned by the company I work for. There are approx 40 fields that the person doing the H&S check has to fill in with either "yes" or "no". If "no" is chosen, then there is follow-up action required.
I now need to create a report that shows any Facility with any "no" on any one of the 40 fields.
If I create a SELECT query using Where [Field_1] = "No" or [Field_2] = "No" or [Field_3] = "No" etc etc up to Field_40, then I get the data I want, however of course I also get the "Yes" data that I don't want to report on.
The only way I can think of achieving what I want, is to create 40 different SELECT queries, bringing through one field at a time, and then joining them all together with a UNION query.
However, obviously this isn't an efficient solution!
Does anyone have any ideas on how to handle this type of issue?
Cheers,
Kirsti