Sort with null / blank entries last

  • Thread starter Thread starter justme
  • Start date Start date
J

justme

How can I have a report sort a field with dates in such a manner that blank
/ null entries are last?

TIA for the help!

JustMe
 
Make the RecordSource of your report a query. Then, in that query create a
calculated field such as the following and use it as your
primary or first sort in the Report's Sorting and Grouping options:

IIf(IsNull([MyDateField]),9999,1)

Then make your Date field the second sort.

hth,
 

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

Sorting with null / blank fields last 2
Grouping and Counting null records 2
#error - Blank 3
Conditional DB reports 3
changing background color in a field based on a null value 1
sorting: cleared/null v/s "" 3
Prevent report from running if a field is null 2
Sorting on the value of a text box in each record? 2

Back
Top