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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question cc Sorting reports into a specific order 1
Trouble with my sorting and grouping 2
Coordinating the sort order in a report with the underlying query 2
sorting fields 1
Sorting records in the Report Design View 1
Sorting and Grouping 2
Sorting dates within groups. 2
descending order 2

Top