Sorting by Date()+Time() field

[Guest]

I have a subform controlled by a simple Query. The order of the records on
the subform are sorted by Date in acsending order using the Query.Can anyone
tell me why occasionally the sort order is incorrect ie. Dates in the wrong
order. I use XP home and Access 2003.
Thanks

 

[Douglas J. Steele]

Is it a Date field, or date being stored in a Text field?

How are you sorting: through a query with the appropriate ORDER BY clause,
or by using the OrderBy property of the form?

 

[Guest]

In the underlying table the date is in a date field. The data is sorted using
the sort field in the query in which acsending is selected

 

[Van T. Dinh]

Is the "sort field" in the Query simply the Table Field or a Calculated
"Field"?

If it is, its result may be of Text data type and the sorting will be done
based on Text values and not Date value.

Post the expression you used for the Calculated "Field" in this case.

 

[Guest]

the "sort field" is a table field and not a calculated field
--
Don

Is the "sort field" in the Query simply the Table Field or a Calculated
"Field"?

If it is, its result may be of Text data type and the sorting will be done
based on Text values and not Date value.

Post the expression you used for the Calculated "Field" in this case.

 

[Van T. Dinh]

Post relevant details of your Table(s) and the SQL String of the Query.