Build the query

- [Voiceover] The next step in creating our reporting tool…is to construct the query.…The query will be easier to test out…if we have some values populated in these combo boxes…here on the Main Menu form,…so let's go ahead and make a few selections.…I want to take some values from 2016 in January…and the East North Central division…and I want to compare those to 2016 January…in the Mid Atlantic subregion.…Let's go ahead and make those choices here…at this Main Menu and we'll just leave them in place.…Then, we'll turn our attention here to the Create tab…and we'll start our new query in Design View.…

For our query we're going to need some information…out of the Orders table.…That'll give me links to the customer that placed the order,…the product that was ordered, as well as the date…that the order was placed.…Then, I'm going to pull information…out of the Customers table…which will tell me the state that the customer lives in…and we can get the related subregion from the States table.…So I'll go ahead and add that one in.…