You don't need an expertise in SQL to limit the number of records in a group. With your user knowledge of queries and reports, you have all the expertise you need.

Did you know that you could calculate fields in the query in Microsoft Access? In this tutorial we will explain how to create Calculated Fields in Access.

Also, if you right-click on the query title bar, you will see a 'show SQL' option, and it will open a little window to show you the SQL statement which Access generated from your query.

Effectively maintaining an Access database requires the regular removal of duplicate records. The Find Duplicates Query wizard handles this chore quickly and easily.