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
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?

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.

butabika-jon is offline   Reply With Quote

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 08:30 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit

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