Tuesday, May 24, 2011

Consolidating Your Data With Queries

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.

No comments: