Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
 
 
Thread Tools Rating: Thread Rating: 12 votes, 5.00 average. Display Modes
Prev Previous Post   Next Post Next
Old 12-02-2008, 01:47 PM   #1
kevisull
Registered User
 
Join Date: Dec 2008
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
kevisull is on a distinguished road
Crosstab Query Column Headings

I have a crosstab query with 6 row heading fields and then the field [FTE_DATE_YM] as the column heading and the field [Hours] as value which is a sum. The FTE_DATE_YM field is a series of 12 months in this format 200801, 200802, 200803 etc. The query works fine.

The issue I am having is I want the column heading to be consistent no matter the month date so I set query properties column heading to this: "Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"

When I do this the column heading appear as I want but then the [Hours] value field which is a sum no longer shows any numbers. I do have a Total of Hours row field which does show the correct total of hours for the months but the individual months have no values.

kevisull is offline   Reply With Quote
 

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Column Headings Crosstab Report natep26 Queries 6 09-08-2008 11:44 PM
column header error in crosstab query TLJ Queries 1 01-23-2005 09:51 AM
[SOLVED] Crosstable query returns too many records Palsam Queries 2 03-09-2004 11:41 AM
Problem with a report based on a crosstab query AshikHusein Reports 4 07-02-2003 04:55 AM
Crosstab Column Sort Dugantrain Queries 1 02-03-2003 08:21 PM




All times are GMT -8. The time now is 05:59 AM.


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

Featured Forum post


Sponsored Links


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