Sort with null / blank entries last

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
 
C

Cheryl Fischer

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,
 
Top