I have a continuous form where I press a button to show Open records and have them sorted by their required date. So I have this:
Me.OrderBy = "RequiredBy ASC"
Me.OrderByOn = True
This works well for records with a required by date, but for records that have no date, they show up first. I would like them to show up last and can't find a way to do this.
Any ideas?
Thanks
Me.OrderBy = "RequiredBy ASC"
Me.OrderByOn = True
This works well for records with a required by date, but for records that have no date, they show up first. I would like them to show up last and can't find a way to do this.
Any ideas?
Thanks