Hi all, Thanks in advance for your help.
I am currently creating a report to show what equipment all customers have purchased. I have set out the query to reflect the report, in our cust table we have 2 fields, one indicating the customer no longer needs the equipment and the second field indicating the customer has left us. These are two base enums where 0 = No and 1 = Yes.
Upon running my report I want to select no longer need the equipment as 0 OR the customer left us field as 0. However in designing the query I can only select no longer needing the equipment as 0 AND the customer has left us field as 0. How do I design the query so the report so that will ommit if the customer no longer needed field is ticked (=1) OR the customer has left us field is ticked (=1)?
Let me know what you think, or if you need clarifications
Nik M