Consider how you determine which field and function is good to use for aggregating the data in a crosstab query.

What will be an ideal response?


The summarized data in a crosstab query is displayed at the intersection of the rows and columns. The values that are displayed depend on which aggregate function you choose when you create the crosstab query—sum, average, and count are common examples. The field and function that you use depends on the values you want to summarize, for example, order values that can be summed or averaged by salesperson, region, or customer. Determine which field needs to be summarized, and which function is needed for the result you want.

Computer Science & Information Technology

You might also like to view...

Which of the following prints the address of character string string given the following declaration? char * string = "test";

a. cout << string; b. cout << *&string; c. cout << static_cast< void * >( string ); d. cout << * string;

Computer Science & Information Technology

__________ is an example of a proprietary operating system.

a. UNIX b. Macintosh OS X c. Linux d. All of the above are proprietary operating systems

Computer Science & Information Technology

Name the general steps for adding text to a grid plane

What will be an ideal response?

Computer Science & Information Technology

What are some of the advantages and disadvantages for using HTML5, over

HTML 4, markup? What will be an ideal response?

Computer Science & Information Technology