Group By Table button

Groups records on a table or a query. Use to group records when the data access page contains fields from two tables or queries that have a one-to-many relationship, and you want to group on the table or query on the "one" side of the relationship. When you use Group By Table to group records, Microsoft Access groups and sorts records using the table's primary key.