From the course: Access 2019: Tips, Tricks, and Techniques

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Build the query

Build the query

From the course: Access 2019: Tips, Tricks, and Techniques

Start my 1-month free trial

Build the query

“

- [Instructor] The next step in creating our reporting tool is to construct the query. Now, it's gonna be easier to get results in our query if we have some selections made here in these combo boxes. So I'll just go through and select a couple of values. How 'bout January 2018 in the East North Central region. Then we'll compare those records to February 2018 in the East North Central Region. I'm just gonna leave these values here on the main menu, and then we'll come up to the Create tab, and we'll start building in query in Design view. For the tables that I want to use, we'll start with the Orders table. That will give us the product that was ordered as well as the customer ID for the customer that ordered it. To get to the state information, I'll add in the Customers table. That'll give us the individual state that that order went to. I'll also add the States table, which will translate that state into the sub region that it belongs to. Finally, I'll also add in the products…

Contents