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

  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


<Doug Klippert@ 3:01 AM

Comments: Post a Comment

Links to this post:

Create a Link