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
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 12:03 AM.

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

Featured Forum post

Sponsored Links

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