The dynamic array function, UNIQUE() has been around for a while, so it’s possible that you already know how to use it. If that’s the case, feel free to skip this section.

The Count function helps you easily create a query that, based on any criteria, sums up the number of Access records you have. Here's how to use it.