Special Edition Using Access 97, Second Edition

Chapter 10. Creating Multitable and Crosstab Queries

Your purpose in acquiring Access is undoubtedly to take advantage of this application's relational database management capabilities. To do so, you have to be able to link related tables based on key fields that have values in common—a process known as a join in database terms. Chapters 8, "Using Query by Example," and 9, "Understanding Operators and Expressions in Access," showed you how to create simple queries based on a single table. If you tried the examples in Chapter 9, you saw a glimpse of a multiple-table query when you joined the Order Details table to the Orders table, which you then joined to the Customers table to create the query for testing expressions. The first part of this ...