Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012

    Unanswered: Create expression for Date of Birth excluding the Year

    I hope someon can tell me how to sort partial date values. I have tried to follow the help link but I get confused. I want to sort a table by the month and day of the birth but exclude the year. My expressions seem to trigger a parameter window to pop open.

    Thank you.

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    It should be something like:
    SELECT... FROM... ORDER BY Month([DOB]), Day([DOB])
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts