Displaying birthdays from the birth date

  • Thread starter Thread starter K
  • Start date Start date
K

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.
 
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.
Click to expand...

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.
 
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.
Click to expand...

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.
Click to expand...

Thank you, it helped a lot.
 
Back
Top