User`s guide

Fine-Tuning Queries Using Advanced Query Options
5-45
For B, results are first sorted by January sales in ascending order. The lowest
value for January sales, 1200 (for item number 400455), appears first. The
highest value, 5000 (for item number for 400345), appears last.
For items 400999, 400314, and 400876, January sales were 3000. Therefore, the
second sort key February salesapplies. February sales appear in ascending order:
1500, 2400, and 2400 respectively.
For items 400314 and 400876, February sales were 2400, so the third sort key,
March sales, applies. March sales appear in descending order: 1800 and 1500,
respectively.
Using Having Clauses to Refine Group by Results
Using the HAVING Clauses Dialog Box
Use the Having function to refine the results of a Group By clause.
After specifying a group-by clause in Advanced query options, click Having. The
HAVING Clauses dialog box appears.