Sorting by Date()+Time() field

D

Don

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
 
D

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?
 
D

Don

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
 
V

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.
 
D

Don

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


Van T. Dinh said:
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.
Click to expand...
 
Top