Critera expression for following month

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

 

[KenReay]

Hi

"SELECT * FROM myTable WHERE Month(Birthday) = " & Month(DateAdd("m",1,date())) & ";"

should do it, you have to use your own table/column names of course Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK

 

[ankat]

Thanks for your reply Ken.
Is this correct.
WHERE ((((([Client Infomation]![Birthdate]=Month (DateAdd("m",1,Date())) & ";"
Where do I enter the Surname field in this expression.
I keep getting invalid syntax.

 

[jimmythegeek]

Copy and paste this into the SQL view of a query:

SELECT Surname
FROM [Client Information]
WHERE (((Month([Birthdate]))= Month(DateAdd("m",1,Date())))); Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?