Re: Sort Ascending

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,
you can add one more column to your form's recordsource query, replace null values with max date could be, say 1/1/2040 using Nz() and then sort form by this column

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

"ladybug via AccessMonster.com" <u21071@uwe> wrote in message news:67f37481c26d0@xxxxxx
I am trying to sort a list of dates on a continuous form. I want it
ascending. However, there are some entries that do not have any dates. I
want these entries to be at the bottom.
Currently, these entries without dates are at the top because of the
ascending sort.

Any ideas?

--
Message posted via http://www.accessmonster.com


.