On Sun, 6 Nov 2005 19:20:42 -0600, "John"
An alternative approach is to include a calculated field:
HappyHappy: DateSerial(Year(Date()), Month([DOB]), Day([DOB]))
This will contain the current year's birthday anniversary, and can be
formated, sorted, searched etc. just like any other date/time field.
John W. Vinson[MVP]