Bookmark and Share

Enter your email address:

Delivered by FeedBurner



Home Page













Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Sunday, May 03, 2009 – Permalink –

Crosstab Query Column Headings

Using Month Numbers


If you display a crosstab query as a datasheet, consider using a month's or day's number as a column heading instead of a text abbreviation (e.g., 1 instead of Jan or January, or 2 instead of Mon).

Text abbreviations are sorted alphabetically. Apr appears before Feb, Mon appears before Sun, etc. Number representations will sort in their proper order.


[Edited entry from 3/8/2006]




See all Topics

Labels:


<Doug Klippert@ 3:01 AM

Comments: Post a Comment

Links to this post:

Create a Link