Solved

Producing a Report from Crosstab query

Posted on 2011-03-08
3
191 Views
Last Modified: 2012-05-11
A similar question has been asked several times before, but none have quite answered mine sufficiently.
I have an Access crosstab query which is used to produce a Report. The problem is the columns that the query produces are different each time. The report needs to know which columns to expect, but it's impossible to know.

Is there a way around this?
0
Comment
Question by:rick_danger
  • 2
3 Comments
 
LVL 9

Accepted Solution

by:
mayank_joshi earned 250 total points
Comment Utility
Following Article may help:-

http://allenbrowne.com/ser-67.html
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 250 total points
Comment Utility
Sure, see these links, and get ready to rock...
(Hope you are good at VBA coding...)

http://support.microsoft.com/kb/328320
http://www.blueclaw-db.com/report_dynamic_crosstab_field.htm

;-)

JeffCoachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
<A similar question has been asked several times before, but none have quite answered mine sufficiently.>
This is because this is not inherently an easy thing to do...

So I am not sure any posts here will make this any less painful...

;-)

JeffCoachman
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

772 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

12 Experts available now in Live!

Get 1:1 Help Now