Not Sorting Properly

E

EddieLampert

So I go in Sorting and Grouping in design view, sort date by descending, but
it still does not work fully. The Dates are in no particular order. Thanks
for any help.
 
M

Marshall Barton

EddieLampert said:
So I go in Sorting and Grouping in design view, sort date by descending, but
it still does not work fully. The Dates are in no particular order. Thanks
for any help.
Click to expand...


Your date field is probably a Text field. If the contecxts
of the field are all legal Access dates, then you can use
Sorting and Grouping on an expression like:
=DateValue(datefield)
 
E

Evi

If by any chance you have used NZ in the query on which the report is based
(to avoid null values) then your dates will have probably been turned into
text.
Surround your NZ function with DateValue
DateValue(NZ([YourDateField],#YourDefaultDate#))

I've found that this also happens with number fields (you can spot it
because they become right aligned) so I surround those with Val.
Evi
 
Top