You can find contacts based on criteria in multiple fields or based on multiple criteria in one field. Other Lookup commands require multiple lookups to add to or subtract from a set of contacts.
You can save and reuse a query and add a command to the Lookup menu to run a saved query. (You cannot do this with other lookups.)
You can use a saved query to dynamically add contacts to groups and subgroups.
You may find that you need to create an advanced query to find the information
that you want. Advanced queries use advanced operators. For example, to
find all contacts in the U.K. whose sales volume is more than 10,000 units
and all contacts in Germany whose sales volume is more than 20,000 units,
you need to create an Advanced query. You create an Advanced query by
converting a By Example query.
For more information, see Tips
for creating queries.
About queries
If you cannot find contacts using the Add To Lookup and Narrow Lookup options in the Lookup dialog box, use the By Example Lookup command to create a query. A query searches by comparing all contacts in the open database with multiple criteria that you specify, and creates a lookup of contacts that match those criteria.
Learn more about