DateAdd help please

[ankat]

I am looking for a criteria expression using access that lists all peoples names (from my surname field) if they have a upcoming birthday during next month (from my birthdate field).The table containing the surname field and birthdate field is called client information.
Any help would be greatly appreciated
WHERE ((((([Client Infomation]![Birthdate]="& Month(DateAdd("m",1,Date())) & ";"
Will this work?
Where do refer to the Surname field in this expression.
I keep getting invalid syntax message

 

[mwolf00]

This should do it:

select surname, birthdate from myTable where datePart("m",birthDate) = datePart("m",dateAdd("m",1,date()))