Access Where Clause: The Difference Between Group By and Where in Microsoft Access Queries

Access Where Clause: The Difference Between Group By and the Access Where clause

Simple Access queries show detail, line by line records but summarising your data requires the Groups and Totals query. However, how you apply criteria may have an effect if you do not follow the rules. Using the Access ‘Where’ clause can be a better way to apply criteria to your query.

This video tutorial (less than 5 minutes) will explain the use for an Access Where clause query instead of using the ‘Group By’ option…

Access Where Clause: The Difference Between Group By and the Access Where clause

To clarify and confirm, the Access Where clause cannot be seen (or is visible) to the output of an Access query unlike the ‘Group By’ option which affects data distribution.

This is a useful attribute especially when handling complex criteria that sits in the background and is processed first before the output is called which is what the ‘Where’ clause means.access where clauseTo learn more about this type of query and other advanced Access queries, take a look at my eBook offer on More Access Database Queries.

This entry was posted in MS Access, Queries and tagged , , , , . Bookmark the permalink.

One Response to Access Where Clause: The Difference Between Group By and Where in Microsoft Access Queries

  1. Ben Beitler says:

    If you look at the SQL view of a groups and total query, you will see the WHERE clause is in a different place to criteria and the HAVING keyword is a clue to hidden criteria.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>