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

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
 
A

Allen Browne

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

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

How to sort on birthdays 2
How do I post a result of a query to a text box? 0
How do I list dates without years? 1
Dates driving me to drink. 10
How do I get ACCESS to calculate years, months, days for a birth d 2
displaying multiple dates in a table 4
How do I calculate a person's age from date of birth and a date 2
date of birth age formula 8

Top