Access - working with dates

P

Paul Walshe

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.
 
A

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.
 
Top