birthday in more than one field

[manojsikar1]

dear all.....I am making a project for a school administrator...He want to wish on all special occasions like b'day of teacher, b'day of his father, marriage annv etc.... I made a single query where all the field are mentioned......Now I want to make a query were only b'day of today are highlighted of all members....


plz help

 

[John Big Booty]

You could test;

[URL="http://www.techonthenet.com/access/functions/date/day.php"]Day[/URL]([URL="http://www.techonthenet.com/access/functions/date/date.php"]Date()[/URL]) = Day(DOB) And [URL="http://www.techonthenet.com/access/functions/date/month.php"]Month[/URL](Date()) = Month(DOB)