From the course: Office 365: Access Essential Training

Unlock the full course today

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

Getting a different look with crosstab queries

Getting a different look with crosstab queries - Microsoft Access Tutorial

From the course: Office 365: Access Essential Training

Start my 1-month free trial

Getting a different look with crosstab queries

“

- Queries generally follow the rows and columns, or records and fields model for their layout. We have a slightly modified layout option available to us, called a Crosstab Query, that gives us headers along the top and side and then aggregate, or summary, data that appears in the middle. Let's put one together that takes a look at the visits to our various room options at the hotel. Now, the Crosstab Query is just a variation on a Totals Query, so we'll start there, and then convert it over to a Crosstab Query. In order to create that Totals Query, we start in the Create tab and go ahead and visit the Query Designer here. Now, I'm going to add in some information from my RoomAssignments table here, and then I also want the Rooms data, so that I can get some information about the types of beds that we have available in our rooms. Go ahead and close down the Show Table window here. And I'm going to double-click on RoomName and Bed, to add both of those columns down here into my query…

Contents