HOW DO I RETREIVE ONLY BIRTH MONTHS FROM BIRTHDAYS 1/20/55

  • Thread starter Thread starter pat9103
  • Start date Start date
P

pat9103

I am creating a data base that will have customers date of birth, and
spouse/significant other date of birth. Each month I will need to run a
query that will show me the names of people born in that month so I can send
cards. I have been unable to find the format for this in any of the help
menu's can some one help me please. Many Many Thanks
 
In query design view, type an expression like this into the Field row:
TheMonth: Month([DOB])
substituting the name of your date-of-birth field for DOB.

In the next column, enter:
TheDay: Day([DOB])

This will return a number for the month (1 to 12) and a number for the day
of the month (1 to 31.)
 
Back
Top