how_to_create_a_query_in_access_8 Published May 19, 2016 at 542 × 152 in How to Create a Query in Access ← Previous Next → Only records with a value greater than $80,000 are returned. This is because we specified >80000 in the Criteria field.