RE: pivot tables
Hi Sheila
A Pivot table allows you to easily sort and view the data in a table in whichever way you need to.
You can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data.
Pivot tables are useful to create crosstabs quickly. You set up and change the summary's structure by dragging-and-dropping fields graphically. This "rotation" or pivoting of the summary table gives the concept its name.
To do this:
1. In the Tables area of the database
2. Select and open the required table
3. Select the View menu and click Pivot Table view
The table turns into a blank Pivot table
Move the fields you wish from the Field list to the table
Hope this helps
Carlos
