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 […]

Tags: access groups and total queries, access where clause, how to use the where clause in access, microsoft access queries, ms access query totals, ms access where clause