Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS Access

Posted Jul 1, 2003

MS Access for the Business Environment: Create a PivotTable View in Access - Page 6

By William Pearson

Formatting and Organizing the PivotTable View

Next we will examine ways we can organize the new PivotTable view to make it easy to use. We will format and organize our view, then briefly examine filtering, sorting and grouping.

1.      Click the new Sum of Net Sale calculated total in the PivotTable view to highlight it.

2.      Click the Properties button (shown in Illustration 26) on the PivotTable toolbar.


Illustration 26: The Properties Button on the PivotTable Toolbar

The Properties dialog appears for the Sum of Net Sale calculated total field.

3.      Click the Captions tab.

4.      Input Total Net Sale in the Caption text box.

The Properties dialog, Captions tab for the Total Net Sale calculated total appears as shown in Illustration 27.


Illustration 27: The Properties Dialog, Captions Tab, for the Total Net Sale Field

5.      Leaving the Properties dialog open, click the label for the new Count of Net Sale calculated total field on the PivotTable.

The Properties dialog switches to display the settings for the Count of Net Sale column.

6.      Input No. Line Items in the Caption text box.

The Properties dialog, Captions tab for the No. Line Items calculated total appears as shown in Illustration 28.


Illustration 28: The Properties Dialog, Captions Tab for the No. Line Items Field

7.      Close the Properties dialog.



MS Access Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS Access Forum
Topic By Replies Updated
Help With Microsoft Access kasy 0 September 4th, 07:35 PM
Linked table not sorting or filtering - ODBC error Java 1 August 28th, 10:37 AM
Use Parameter in select statement (Sql in Microsoft Access) katty.jonh 1 July 25th, 06:45 AM
Query Issue algebroni 7 July 23rd, 04:22 PM


















Thanks for your registration, follow us on our social networks to keep up-to-date