Birthday

[manojsikar1]

Hello evryone...
can any one plz help me out to list Today's Birthday in form....
I have list of students in my query....I want some criteria were I can get the list of students whose b'day are today...

plz help

 

[nanscombe]

All you need is a query along the lines of ...

SELECT * FROM yourTable WHERE Format([yourBirthdayField],"mmdd") = " & Format(Now(), "mmdd")

This basically picks out any dates where the "Month and Day" part of your field matches todays' "Month and Day".

Or, if you are using the query design page, a column something like BD:Format([yourBirthdayField],"mmdd") with the criteria Format(Now(), "mmdd")

 

[manojsikar1]

thnx dear it really worked....

 

[nanscombe]

You're welcome and ... welcome to the forum.