Whenever you add more than one criterion to report or filter on, you must assign a connector to show the relationship between the two.
Inform supports 4 connectors:
- And: Both criteria must be met on each record for it to be returned. Use And when you are joining multiple properties of a record, such as
- Salesperson = John Smith
- YTD Sales > 100,000.
- And with: Designates a grouping of criteria in which criteria for both groups must be met.
- YTD Sales > 100,000
- Salesperson = John Smith
- Salesperson = Mary Smith
- Or: One of the criteria must be met for the record to be returned. Use Or when you want to return records that meet at least one of the criteria, such as
- Salesperson = John Smith
- Salesperson = Mary Smith
- Or With: Designates a grouping of criteria with OR between groups
- Last Year Sales > 100,000
- AND
- Salesperson = John Smith
- OR WITH
- Salesperson = Mary Smith
- returns customers with John as a salesperson and over 100,000 in sales, or all customers with Mary as a salesperson regardless of last year sales.
AND
returns all customers of John with sales over 100,000.
AND WITH
OR
returns customers with over 100,000 in sales that have either John or Mary as the salesperson.
OR
returns customers with either John or Mary as their Salesperson