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

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

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");