Not Sorting Properly

  • Thread starter Thread starter EddieLampert
  • Start date Start date
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.
 
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
 
Back
Top