Access - working with dates

[Guest]

Have Sports club membership, with D.O.B. as **/**/**** - need simple query to
show birthdays for each month without having to show year - bit dumb on this
one - you are addressing the lowest common denominator.

 

[Allen Browne]

Type this expression into the Field row in query design:
Birthday: DateSerial(Year(Date()), Month([D.O.B.]), Day([D.O.B.]))

That shows the person's birthday this year.