Aggregate queries which centre around the Totals button in the query design tab in access, allows users to create queries that not only select certain rows from tables but also performs different calculations on the data contained within those rows. The calculations include Count, Sum, Average, Min, Max along with other statistical functions. This tutorial outlines a simple count mechanism using a criteria across a one to many relationship.
On this page of the site you can watch the video online Aggregate Queries Count Example Access with a duration of hours minute second in good quality, which was uploaded by the user Q Visible 07 February 2015, share the link with friends and acquaintances, this video has already been watched 75,810 times on youtube and it was liked by 363 viewers. Enjoy your viewing!