User's Manual

21-1
Chapter 21
Advanced Queries
Title Page
21.1 Advanced Queries................................................................................... 21-3
21.1.1 Running Previously Saved Advanced Queries ................................... 21-3
21.1.2 Creating New Advanced Queries and Modifying Existing Queries... 21-3
21.1.2.1 Display Fields Section.................................................................... 21-4
21.1.2.2 Sort Fields Section ......................................................................... 21-5
21.1.2.3 Selection Criteria Section............................................................... 21-5
21.1.2.4 Wildcard Characters (Matching Parts of Strings using
“LIKE” and “NOT LIKE”) ......................................................... 21-6
21.1.2.5 Using Date Field Key Words ......................................................... 21-8
21.1.3 Action Button Sets.............................................................................. 21-9
21.1.3.1 Action Buttons Set 1 (shown beside the Selection Criteria
During Query Execution box)....................................................... 21-9
21.1.3.2 Action Buttons Set 2 (shown below the Selection Criteria
During Query Execution box)....................................................... 21-10
21.1.4 Navigating Between Records Included in an Advanced Query List .. 21-10
21.1.5 Printing Lists and Saving Them to External Files.............................. 21-11
21.1.6 Using Advanced Queries in Other Parts of the Program.................... 21-11