Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003

    Unanswered: Problem with sorting in Crosstab Qry

    I have a crosstab query that is using a date field for the column heading. I need the columns to sort in ascending order, however, this isn't working properly.

    For example, the column 01/01/2004 is before the column 04/30/2003

    Any ideas?

  2. #2
    Join Date
    Aug 2003

    Re: Problem with sorting in Crosstab Qry

    What is the date format/date separator on your machine? One solution is to use the Format function to display dates as strings in the yyyy/mm/dd format:

    Format([MyDate], "yyyy/mm/dd")

    Make sure you use 4-digit years in case you have date prior to 2000.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts