Displaying birthdays from the birth date

[K]

Hello. I have a brief question, of how do i do some sort of label
which displays what persons in my database were born on this day...
considering that i enter the whole date of their birth in the database.

 

[fredg]

Hello. I have a brief question, of how do i do some sort of label
which displays what persons in my database were born on this day...
considering that i enter the whole date of their birth in the database.

Create a query. Include the person's [NameField] and a new column.

Birthday:Format([DateOfBirth],"mm/dd")

As criteria on this Birthday column, write:
Format(Date(),"mm/dd")

Only records with the current month and day will be returned.

 

[K]

Hello. I have a brief question, of how do i do some sort of label
which displays what persons in my database were born on this day...
considering that i enter the whole date of their birth in the database.

Create a query. Include the person's [NameField] and a new column.

Birthday:Format([DateOfBirth],"mm/dd")

As criteria on this Birthday column, write:
Format(Date(),"mm/dd")

Only records with the current month and day will be returned.

Thank you, it helped a lot.