What is a Group in a Query, and how do I perform a calculation with a Group in Access 2007? The Group feature in the Design view of a Query is used to add a Totals Row. This Totals Row will either perform a calculation for all fields in you've added to your Query, or group them. So for example, you wouldn't want to add up or perform a calculation on a text field like say a field named Clients. However, if you leave the default "Group" option set then it will group all or any duplicate Clients into one. You could have duplicate Clients in a Query if you build it to include say Clients and their orders. So every order listed you'd also have listed the Client's name. Watch our video!

Purchase the training video and you can see this in action for yourself!