• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Locating and Managing Data w... > Summarizing Values with a Crosstab Q...

Summarizing Values with a Crosstab Query

A crosstab query allows you to summarize the contents of fields that contain numeric values, such as Date fields or Number fields. In this type of query, the results of the summary calculations are shown at the intersection of rows and columns. For example, you can use a crosstab query to calculate the total number of patient encounters you had, broken down by chief complaint. Crosstab queries can also involve other functions such as the average, sum, maximum, minimum, and count. You cannot update crosstab queries. The value in a crosstab query cannot be changed in order to change the source data.

Create a Crosstab Query

In the Database window, click Queries on the Objects bar, click New, click Crosstab Query Wizard, and then click OK.

From the list at the top of the dialog box, select the table or query that contains the records you want to retrieve.

Click Next to continue.

Double-click the field(s) you want to use in the crosstab query.

Click Next to continue.

Select the field for the columns in the crosstab query.

Click Next to continue.

Click the field whose values you want to be calculated and displayed for each row and column intersection.

Click the function you want for the calculation to be performed.

Select the Yes, Include Row Sums check box if you want to see a total for each row, or clear the check box if you do not want to see a total for each row.

Click Next to continue.

Enter a name for your query.

Indicate whether you want to immediately view the query or modify the design.

Click Finish.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint