AnsweredAssumed Answered

Move empty fields to the end of the found set

Question asked by LeszekŁuczkanin on Mar 6, 2014
Latest reply on Mar 6, 2014 by philmodjunk

Title

Move empty fields to the end of the found set

Post

     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.

      

      

      

Outcomes