Access - working with dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

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