Excluding values in a Query (1)

I have a query problem. I am trying to exclude data and pull up the rest. Example: I want to exclude all people who have had gum disease, knee trouble and high blood pressure and get all the remainder, being the rest of the conditions for everyone. Is this possible?

To do this:

In the criteria row of the relevant field column, enter:

Not Like "High Blood Pressure" And Not Like "gum disease"......etc.

Do you like this tip? Subscribe to my free weekly Newsletter to receive tips weekly via email. Click Here to subscribe.