Starting a Query

1
Starting a Query

• Table Fields
• Query Wizard

• Query Toolbar
• Run button

2
Query Results

• View Button
• Sort Button

• Filter Button
• Delete Records

3
Criteria

• Text DataWildcards ? One character
• several characters
• Numbers dont need
• Comparison operators lt gt gt lt NOT
• Unchecked boxfield not in results
• ANDon same line (like this picture)
• OR on Criteria line and or line

4
Sorting
Ascending A to Z or lowest to
highest Descending Z to A or highest to
lowest Field on left controls sort Other
fields not sorted Uniquey/n
5
Joining Tables

• Add second, joined table
• Can use criteria joining

No criteria ? ? gt1000
6
Calculations
7
Statistics and other sorting

• Can use statistics criteria
• Grouping done by common characteristics
• More details at http//scsite.com/ac2000/qrac2000
  b.htm
• Quick Reference Summary
• Page numbers are for Access2000 books