I have builta simple query that includes information from 31 different companies. The query operates perfectly. Is there any easy way to filter out or excludedata from 7-10 of these companies using criteria? If yes, how? Thank you in advance.
I have builta simple query that includes information from 31 different companies. The query operates perfectly. Is there any easy way to filter out or excludedata from 7-10 of these companies using criteria? If yes, how? Thank you in advance.
Sure. In the Criteria row of that company field, have something like:
Code:Not in ("Company1","Company2",...)