Access - working with dates

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting multiple memberships 1
query will not work between years 7
linked fields in a query 3
A Brexit Story 1
SQL help requested 2
Access query to compare dates 1
Calculating Amounted owed. 1
Upcoming dates 6

Top