Query processing
Queries are frequently processed by a user in daily interactions with the software. Multiple options exist to make query processing easy. Query processing is executed by clicking on the Process button in the Standard toolbar or by clicking on the Tools | Process Query | Current menu option. After the query has finished processing, the software will populate the Results section with the data requested in the Query section.
Note
The Status bar will show the number of rows returned from the query in both the Query and Results section after a query has finished processing.
In addition to simple processing, a few other options exist for processing multiple Query sections in a particular order. Using the previous example, the Q_Sales section is duplicated by right-clicking on the Q_Sales name in the Section window and selecting Duplicate Section. Repeating the process will add a third identical query. Since the section names must be unique, the software renames the section by adding...
