Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

crosstab query

guys, how come my cross tab query cannot work below? i've got a value, row and column field.
crosstab1.png
crosstab2.png
0
developingprogrammer
Asked:
developingprogrammer
1 Solution
 
als315Commented:
You can have many Row Headings, but you had to have one (only one) Column Heading and one (only one) Value
0
 
developingprogrammerAuthor Commented:
I see als315. Then the better option is to export to excel then pivot cause it's more robust. Thanks!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now