[AccessD] Date field sort

Debbie,

    If the problem continues to persist, despite trying out on a freshly created report built from scratch, are you in a position to make a skeleton zipped file having just a few records demonstrating the problem? If so, I could look into it.

Best wishes,
A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: Elam, Debbie 
  To: 'Access Developers discussion and problem solving' 
  Sent: Saturday, January 06, 2007 03:52
  Subject: Re: [AccessD] Date field sort


  This is not precisely formatting.  It is explicitly defining this as a date
  type for sorting purposes.  

  I have both used this and not.  They alternate as to which sorts the field like a date or like a string.  Since the underlying field is a date field, I did not do this originally as it was not necessary and should have stayed that way.

  I see options in the report for changing how it looks visually, but not it's data type (and therefore it's sort properties).  If this is something I have missed, let me know where to find it.

  Debbie

  -----Original Message-----
  From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg] 
  Sent: Friday, January 05, 2007 4:02 PM
  To: Access Developers discussion and problem solving
  Subject: Re: [AccessD] Date field sort

  Are you applying a format to the Date field in the query underlying the report?  That will have this sort of effect.  As a general rule, you 
  shouldn't do any formatting of data in queries which are used for reports. Do all of the formatting in the report 

  On 5 Jan 2007 at 10:03, Elam, Debbie wrote:

  > I have an odd problem with a report that sorts on a date field.  
  > 3 times now for no reason I can discern the sorting gets strange.  The first time it happened, I used Cdate([MyDateField]) and it started sorting correctly again.  Then I had to take the Cdate() off, then put it on again. Only one or the other works, but they alternate.  
  > 
  > The wrong sorts will sort like a string.  Months are grouped together regardless of year and december comes before January.  And yes, I have had it sort like a string when I used Cdate().  
  > 
  > Has anyone seen anything like this in the past?
  > 
  > Debbie