Setting up and using queries correctly can sometimes make or break an application. Access gives you a number of very powerful query types, so you don't have to go to code to extract the information you need. The way data is set up goes a long way to creating optimized queries.
Chapter 2, “Coding in Access 2000 with VBA,” discusses some of the VBA syntax and how to use the DoCmd object to a greater extent.
Chapter 5, “Working with Data Access Objects,” gets into working with the QueryDef collections with DAO.
Chapter 6, “Introducing ActiveX Data Objects,” gets into working with the QueryDef collections with ADO.
Chapter 11, “Creating Powerful Reports,” shows how to use crosstab queries to create dynamic reports.
18.119.112.152