Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.
Course Of The Month
9 days, 10 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
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| How to retrieve returned values from and MS Access Passthru Query , executing a SQL stored procedure | 19 | 106 | |
| Create a VBA Loop in Access to check records and create and action | 7 | 51 | |
| Cant delete records in query | 8 | 40 | |
| SUBFORM on ACCESS 2013 | 8 | 24 |
Overview: This article:
(a) explains one principle method to cross-reference invoice items in Quickbooks®
(b) explores the reasons one might need to cross-reference invoice items
(c) provides a sample process for creating a M…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette.
This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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…
Suggested Courses
Course of the Month9 days, 10 hours left to enroll
740 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.