I have a Access database that I run a report from. There's 4 yes\no fields that the query looks at to generate the report.
- Access database contains clients
- clients have four items that can be checked (Yes\No)
- Query checks each client and see if they have any checks in those four items
- Form displays the results
My need is to NOT show the any clients on the form that have No for all four items.
I have tried to play around with the Query Criteria "*", Yes Or No and so forth. My knowledge with expressions and functions is minimum. Please let me know what you need to see from the mdb to help.