Tagged Content List

Results for:
query criteria

  • Query Criteria, Part 1: Be specific!

    ( This post was first published in August 2011 and is the first in a series of posts about using query criteria, which includes Query Criteria Part 2: Like what? and Query Criteria Part 3: prompting for input by using a parameter .) Queries are a fundamental part of developing and using any database...
  • Query Criteria Part 3: prompting for input by using a parameter

    In part 2 of this series, we considered using LIKE and wildcards in query criteria to find inexact matches. Good stuff - but what if you could get the query to apply criteria that are supplied when it is run? What if you could make a query ask for input? Good news! You can make a query ask for input...
  • Query Criteria Part 2: Like what?

    In part 1 of this series , we considered a basic example of using criteria in a query to make the query's question more specific. That's great if you know exactly what you're looking for. But what if you want to see inexact matches - say, everyone whose last name starts with Th ? You're in luck - Access...