Move empty fields to the end of the found set
I have a list of persons with several dates.
Some of the fields for some persons are empty. When I sort by field, empty fields are first and I need them to be at the end of the found set.
I also want to make a report which groups persons with anniversaries (50th, 25th, etc.).
I think i need some kind of calculation field to group them, right? Any idea?
And the last question - is there any possibility to make a field with date with only day and month described? I need it for a report with name day, where year is not neccessary. I would like to sort persons to have some kind of reminder, but don't know how to do it.