Access query

B

bcc

I need to create a report based on a query. It's a birthday list.
Unfortunately, the dates include the year which I can't publish. How can I
setup the database so that the query will pull birthdays by the month and
show only dd/mm? I'm a rookie so I need a lot of help.
 
J

John W. Vinson

I need to create a report based on a query. It's a birthday list.
Unfortunately, the dates include the year which I can't publish. How can I
setup the database so that the query will pull birthdays by the month and
show only dd/mm? I'm a rookie so I need a lot of help.
Click to expand...

Create a query based on the table, In a vacant Field cell type

HappyHappy: DateSerial(Year(Date()), Month([DOB]), Day([DOB]))

where DOB is the date of birth field in your table. Leave DOB out of the query
otherwise.

You can display this date using any format you wish, and use criteria such as

BETWEEN Date() AND Date() + 7

to get all the birthdays during the next week.
 
Top