From the course: Access 2019: Building Dashboards for Excel
Unlock the full course today
Join today to access over 24,400 courses taught by industry experts.
Build unique data queries
From the course: Access 2019: Building Dashboards for Excel
Build unique data queries
- [Instructor] There are many reasons why you might need to run a query that show unique values. Maybe you're up against a design flaw in your data or maybe it's just as simple as finding a unique list of departments. Let's take a look at how to create a unique query. Okay, so we have our base query, let's go ahead and save that. Let's go create a new query. And we'll do query design. We're going to go to queries, and just for this example, I'm going to choose the base query. We want to look at a unique list of departments. So I'm going to go ahead and double click Department for my base query. I don't need every department in the organization, I need the departments that are watching the videos. So using my base query shows me everybody in department who's watching the videos. And then I can use a unique statement in order to get a unique list. But let's look at what it looks like before then. So when I run it, I…
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.