Hi everybody i'm new to this forum. I'm John and I would like to ask for the opinion of the experts in this forum regarding my problem in VB6 when querying in ACCESS for birthdays by month, its seems that my query is working but it [u]does not display everybody</u> in the list.
Are there more accurate way to query?

Field: Birthday
DataType: Date/Time

Condition: WHERE BasicInfo.Birthdate LIKE '" & txtMonth.Text & "/##/####" & "'"

:(

If you want to get birthdays in a particular month, then u can use the following:

WHERE month(BasicInfo.Birthdate ) = " & txtMonth.Text


Om Prakash

thanks a lot! I works fine now. I'm still testing it.