sorting null values on reports

[mmaginniss]

I am trying to sort a field ascending by date. Some of the records contain null values and those values appear first on the report when previewed. I would like to change the sort order so that the blank (null) values appear last. Any ideas?

 

[GingerR]

in the recordsource for the report, add a calculated field:
(tweak DateFieldName = your field name)


Sort: IIf([DateFieldName] Is Null,1,0)

sort it ascending. put it to the left of the DATE field. sort the date field ascending too.

g

 

[mmaginniss]

Ginger, this works. Thank you so much.