Query to return birthdays today

[Peter C]

I need to run a query to return the names of people who have a birthday today. I have a table with First Name, Last Name, DOB.
Any help would be greatly appreciated.
Many thanks

Peter

 

[Jeanette]

In the query grid enter Date()in criteria under the DOB field.

 

[Pat Hartman]

It's a little more complicated than that. You need to match only on month and day.

Where Format(DOB,"mm/dd") = Format(Date(),"mm/dd");