The Query button on each data form displays this dialog, which allows you to create both simple and very complex search expressions to display a group of records that match your criteria. When you use the Run Query button, the records that match the query will be displayed in the list area of your data form. Active queries can automatically be used in reports. If you also have either the Purchasing module or the Order Export plug-in, queries can be used to order a specific set of items from the FF&E Worksheet in the same way.

In addition to using the Query button itself, you can also create a simple query by using the "Search in" tool just below any data list to locate a match, then using the tool's Find All option, which creates a query based on your criteria.

For most situations, involving simple queries, you will only need to use the upper of the two condition boxes. See the "Using Queries" section for more details.