PIVOT TABLE

msah el kheir,
with a pivot table, you can fix some kind of 3D table where tasks and resources are alternatively shown as rows and columns and work / cost are summarized in the inner cells.
difference from a classical table is that Excel pivot table is dynamic, i.e. you can move the row headers to columns and vice & versa
have a look at Excel online help, it is most usefull
good luck
Alexandre

Hi there.
Here is online tutor
http://www.contextures.com/xlPivot01.html
(See the bottom of the a.m. page for additional info)

Here is a PivotTable paper found in the Constrcution Financial Management Association web site:

www.cfma.org/documents/PivotTables.pdf
http://www.cfma.org/pivot_dir.htm

You can also get a sample spreadsheet from here:

www.cfma.org/PIVOT.xls

Hope this helps.

Dylan, Andrew and Alexander,

Thankyou very much, They were fantastic leads to findout on Pivots.
Are there similiar sites on Access too...

Regards

Sunil

There is nothing like basics, pivot tables are nothing but bata bases and their indexes. Challenge