Sorting by Date and Time

[Guest_imported]

I'm using Crystal Version 4.5.
I'm using the 'Sort Records' menu to sort the report by a Date-Time field (which is on an Access 2.0 database).
However, this only sorts on the Date part of the Date-Time field and ignores the Time part.
I've tried using the 'Report Options' menu to specify that Date/Time fields should not be converted to Date fields, but this has no effect.
How can I sort by Date and Time?

 

[dcm]

john_crewe: Can only suggest that you check that you are actually getting DateTime and if so create a formula DateTimetoTime(yourfield) and then sort on that within Date David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[EscapeUK]

It might be that the date time field is of a different type in your database. Thats just a long shot