The following select will show the list of people whos bday is today
Select * From Mytable Where ;
Day(bday) = Day( Date()) And Month(bday) = Month(Date())
>Dear all,
>sorry for bothering agani, is there a way to get the programming to pop up a window and pull out specific records with a date field enter... ie I have a bunch of ppl's bday and I want to know is there a way to get the program to give me a window saying those ppl's bday is today... I am not compiling the database, is there a way to do that?
>Thanx
>Tom
--sb--