From the course: Access 2016: Forms and Reports
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Connect the query
- [Voiceover] We're getting close to the final functionality we need for our profit summary. The final step is to connect the combo boxes on the main menu to the query that's driving the report. This will allow the end user to choose the month and regions that they're interested in seeing on the profit summary. To do this, we'll go back into the query that we started this with. We'll right-click on it, and open it straight into design view. Now we're gonna add two filtering criteria, one to the month name field here, and one over here to the region. Let's start with the month name one. I'll come over here to the criteria box below the month name column, and I'll right-click, and go into our expression builder with this option here. Then, we simply need to make a reference to the cboMonth that appeared on the main menu form. We can find that by going into the folder that represents our database here, we'll go into forms, we'll go into all forms, and expand that open, then we'll find…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.