Tried your formula and still not getting what I need. You have been so patient and helpful, let me try with the business description. In my database I have a field called Treatment that can have several variables (Vaccine, bath, fecal, etc.) When an animal comes in I may give them a Vaccine...
Is there any easy way to indicate that you want to look at a field if it is "blank" without listing all the values that are possible in that field?
Malcolm, this does not give me what I want. Let me give you an example:
Data Field called Treatment can contain one or many of the following: Vaccine, Fecal, Bath, Treatment, etc. I only want to see those records that DO NOT CONTAIN "Vaccine" and in addition, I don't want to see the...
I know there is a simple solution with Report Expert that is escaping me. If a data field has multiple possible values and you want to select that data field only if it DOES NOT contain one of the values, what is the formula?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.