Solved

crosstab query

Posted on 2013-01-20
2
309 Views
Last Modified: 2013-01-20
guys, how come my cross tab query cannot work below? i've got a value, row and column field.
crosstab1.png
crosstab2.png
0
Comment
Question by:developingprogrammer
2 Comments
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 38798452
You can have many Row Headings, but you had to have one (only one) Column Heading and one (only one) Value
0
 

Author Closing Comment

by:developingprogrammer
ID: 38798469
I see als315. Then the better option is to export to excel then pivot cause it's more robust. Thanks!!
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now