Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 04-23-2014, 11:31 PM   #1
butabika-jon
Newly Registered User
 
Join Date: Apr 2014
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
butabika-jon is on a distinguished road
Crosstab query with fixed row headings..possible?

Hi
This is my first post ever.
I've setup some crosstab queries with good success and set column headings that appear with blank spaces when there's no data as expected, but I have 1 report that is formatted with set row headings (its a specifically formatted report that i need to produce, that i can't just change).
So I need to basically do the same but with the row headings set (I have got the crosstab working, just not showing the rows with no data as yet).
I have searched on here, but can't find anything that helps, so I presume its either impossible or very hard with a load of code outside of the normal crosstab functionality.
Any help much appreciated...its for a good cause.
Thanks
Jon

butabika-jon is offline   Reply With Quote
 

Tags
crosstab , crosstab query , row heading

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Crosstab query with dynamic headings miketonny Queries 3 05-19-2011 12:18 AM
Column Headings For Crosstab Query dknj30 Queries 1 05-19-2011 12:09 AM
Crosstab Query Column Headings kevisull Queries 8 12-03-2008 08:08 AM
crosstab query and column headings Stew Queries 7 12-07-2001 07:31 AM
CrossTab Query-Force Row Headings DRananahan Queries 2 11-16-2001 06:21 PM




All times are GMT -8. The time now is 11:06 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World