PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Course Of The Month
5 days, 7 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Producing a Report from Crosstab query
Posted on 2011-03-08
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?
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
3 Comments
Active 6 days ago
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
(Hope you are good at VBA coding...)
http://support.microsoft.com/kb/328320
http://www.blueclaw-db.com/report_dynamic_crosstab_field.htm
;-)
JeffCoachman
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s
ManageEngine
webinar, where attendees received a comprehensive look at the ma…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …
Suggested Courses
Course of the Month5 days, 7 hours left to enroll
705 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.