vert line

This Inspector allows you to extract specific information from a database and put it elsewhere in the worksheet.

Extract Queries can be given names and reused whenever necessary.

Some preparation needs to be done on the worksheet before you use the Extract Inspector. You must allocate an area for each of the following Extract ranges:

Data the data you want to inquire about
Criteria where you specify the Conditions you want your data to meet
Destination the area to which rows which meet your Criteria will be copied

In the Extract Inspector, give the Extract Query a name, and fill in the Range details. Click the Extract Button to run the Extract and populate the Destination Range with the rows which satisfy your criteria.

  • The button marked Extract can be Command-dragged ts an Icon on a Tool Holder on the Workbook or to one of the spots in the Toolbar.

See also

 

 

 

Also go to:

Index help

Contents help