From the course: Access 2016: Queries

Unlock the full course today

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

Add information to a crosstab query

Add information to a crosstab query

From the course: Access 2016: Queries

Start my 1-month free trial

Add information to a crosstab query

“

- [Voiceover] Crosstab queries are a little limited in their arrangement, but because they're queries, you can use them as a source for other queries to build on to. Let's build another crosstab manually in the Query Designer, and see how this might be useful. If I open up our Orders table, you'll notice that we have a column here called Status. And it's gonna list whether the order was completed or returned. As a quality assurance and loss prevention measure, I'd like to track the sales people that are attached to each order, and see if there's any discrepancies between the return rate of an order and the employee that's attached to the order. Let's go ahead and close this orders table down, and we'll start a new Crosstabs query by going to the Create tab, and going into the Query Designer. Here, I'm gonna pull the information from the Orders table, and I will close the show table window. The fields I want are the salesperson ID, I'll then scroll down to find the status, and then…

Contents