How to I sort and group my data in my Reports in Access 2007? For example, say you have books as one of your products that you sell. You can group all books by title, where underneath each book is a sorted listing of all clients who purchased that book. The opposite of that would be having say the book, "Fun with Play-Doh" listed 20 times or more, one listing for each different client who purchased the book. Why do that and have a longer report than necessary? In other words, group your clients by book title, with all the clients who purchased the same book grouped under each book title. Also, in our certified training videos we'll show you how to calculate your data too!

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