M.L. Humphrey > Quotes

“vendor for that month and how much I earned on them. Let's go build one of these so you can see how to create a simple summary query using more than one table. First, go to the Create tab and choose the Query Wizard from the Queries section. This is still a simple query, so choose the Simple Query Wizard. Next, select the first table or query that has fields you want to include in your query. In this example that's going to be the Vendor 3 Data Table and I want MonthSale and YearSale. Switch the dropdown to the other table or query you want to use. In my case that'll be the Ebook Link Table. Select the fields you want from that table. I'm going to choose Title. Continue to do this until you have all of the fields you want selected.”
― M.L. Humphrey, Access Essentials