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
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