By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,389 Members | 1,955 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,389 IT Pros & Developers. It's quick & easy.

Access Pivot Table with text

P: 1
I am trying to create a pivot table report within Microsoft Access. I would like the report to display text inside the pivot table. This is not a problem when I view as a pivot table query. However, when I create a cross-tab report or export to excel, the text data is converted to either sums or counts of the text cells. Thanks.
Mar 30 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 2.5K+
P: 2,545
Crosstabs are more limited than pivot tables, but as it stands you have not told us enough to form an opinion one way or the other. Please post an example of what you wish to see in the crosstab, along with details of the SQL underlying your present pivot table report.

Mar 30 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.