Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Pivot Tables - Cell Length Limits
- Thread starter marcoose
- Start date
marcoose: You probably haven't got any replies for the same reason I did not reply before. My first thought when I read your question is this:
Why would you want to see memo fields? The whole purpose of Pivot tables is to summarize data. Memo fields are detailed data. Also, any report you could get from a pivot table would probably be easier to report in Access.
Just by virtue of the purpose of pivot tables, I personally wouldn't even both trying to find a way. Just wanted to put this out there, marcoose. No offense or anything... Brainbench MVP for Microsoft Word
techsupportgirl@home.com
Why would you want to see memo fields? The whole purpose of Pivot tables is to summarize data. Memo fields are detailed data. Also, any report you could get from a pivot table would probably be easier to report in Access.
Just by virtue of the purpose of pivot tables, I personally wouldn't even both trying to find a way. Just wanted to put this out there, marcoose. No offense or anything... Brainbench MVP for Microsoft Word
techsupportgirl@home.com
- Thread starter
- #3
Fair enough - I agree but my resources/bosses/current situation and timescales mean that I can create a sales report with all forecast and actual data totalled up but in addition include a latest comment on a given account. I can use Excel to do this but you are right maybe I should just revert to Access reporting!
Marcoose
Marcoose
Just run a query, hit Query-Totals. In the Group by line for the memo field, just choose Last... Brainbench MVP for Microsoft Word
techsupportgirl@home.com
techsupportgirl@home.com
- Status
Similar threads
- Locked
- Question