Sorting on NULL-Values

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   hello,

I fill my reportcontrol with some data from a accesstable.

in this table some cols are NULL, but the column is a date-type.

the reportcontrol gets the right display, even with Null-Values, but if
i want to sort the mixed "date or null" column i get really strange
results. it moves something, but i dont see any good sorting (it could
be in order like null,null,date,null,date,date,date,null....)

what did i miss? what do i have to know about nullvalues in report-control?

thank you

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
jamesblast Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 15 June 2005 Status: Offline Points: 52	Post Options Post Reply Quote jamesblast Report Post Thanks(0) Quote Reply Topic: Sorting on NULL-Values Posted: 30 August 2005 at 4:04am
	hello, I fill my reportcontrol with some data from a accesstable. in this table some cols are NULL, but the column is a date-type. the reportcontrol gets the right display, even with Null-Values, but if i want to sort the mixed "date or null" column i get really strange results. it moves something, but i dont see any good sorting (it could be in order like null,null,date,null,date,date,date,null....) what did i miss? what do i have to know about nullvalues in report-control? thank you