This was my second ever article for Smart Access back in 1998. Nothing much has changed when it comes to group by queries, if you want to be a good Access programmer, you need to know all the tricks that you can do with these queries.
Microsoft Access's Query/SQL environment, along with its support of functions and complex expressions, makes Access a powerful tool for consolidating data. Access's ability to work with many different database formats also gives you the ability to explore data in many different data sources. As I discovered, there's more to consolidating data than clicking the Totals button in the Query Design window, and I'm going to share that information with you in this article.