Aggregate Queries Count Example Access

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.

[@paulabettasso9056]

Anyone else have tiles advertising other videos appear around the 2 minute mark? They obscure the lower 1/3 of the screen.

[@ashley027027]

Thanks!! This is straight to the point and descriptive. Very Helpful for new access users!

[@QuizFizzRizz]

Dude this video is brilliant. Thank you so much for getting right to the point. Good stuff!!!

[@evonnejenkins6130]

Thanks. My professor's instructions was not as clear!

[@luqman_azeem]

How do i get this value to display as an entry in another table?

[@QVisible]

Probably do a query and use that as a table.

[@Ironbuket]

Once you get the value you want displayed in the query, how would you display that value on an existing form?

[@naruszewiczbjolisky3256]

Thank you , it help

[@alikiani9711]

short and useful