Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel Pivot Table or Access Cross Tab Query Question

I am a scheduler and would like to build a pivot table in Excel or a Cross
Tab Query in Access that shows the data in its original form (text) instead
of calculating the count, sum, avg., etc.

Row headings would have members names. Column headings would have times.
Data items would be the name of the assignment.

Any suggestions would be appreciated.

Thanks.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I NEED TO KNOW THE SOURCE OF A PIVOT TABLE FROM ACCESS in excel FORMULA Excel Discussion (Misc queries) 0 July 20th 06 05:26 PM
Linking parameter query from Access to pivot table in Excel ken1975 Excel Discussion (Misc queries) 2 June 20th 06 01:51 PM
Import from Access to Excel, via pivot table Ali Excel Discussion (Misc queries) 1 March 14th 06 10:42 PM
Conversion of Cross-Tab Formatted data to qualify for Pivot Table Jim May Excel Discussion (Misc queries) 2 April 17th 05 07:13 PM
Excel Pivot Table with Access ExcelQuestions Excel Discussion (Misc queries) 0 April 11th 05 03:37 PM


All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"