View Single Post
Old 12-02-2008, 11:42 PM   #4
Kiwiman
Registered User
 
Kiwiman's Avatar
 
Join Date: Apr 2008
Location: Bath, UK
Posts: 799
Thanks: 8
Thanked 57 Times in 57 Posts
Kiwiman will become famous soon enough Kiwiman will become famous soon enough
Send a message via ICQ to Kiwiman
Re: Crosstab Query Column Headings

Howzit

Hi my code below is the SQL view of a query - to see this on your tool bar select View >> SQL View.

As I see it:
  • You hve changed the column headings properties to your desired output
  • You may not however have formatted the field to be the same as your desired output
    • In the design view of your query:
      • Select the column heading field
      • I expect this will have FTE_DATE_YM in your case
      • it will need to show (or something like it) IIf(Right([FTE_DATE_YM],2)=11 Or Right([FTE_DATE_YM],2)=12,"Month " & Right([FTE_DATE_YM],2),"Month " & Right([FTE_DATE_YM],1))
      • It is bullet 3 above that formats the field to your desired output, therefore the crosstab will pick up the results
__________________
HTH's
Take It Easy
Pete
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Man who keep feet firmly on ground have trouble putting on pants.
Kiwiman is offline   Reply With Quote