J justme Apr 5, 2004 #1 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
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 Apr 5, 2004 #2 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,
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,
