how to get all records of a person in perticular month

[vinoda2005]

Hi friends,

Can anyone send me a query to retrieve all the records of a person in a given month???

Please it is urgent..

Do sql queries and msaccess queries r equal???
Do sql queries run in msaccess??

[xpcer]

Hi friends,

Can anyone send me a query to retrieve all the records of a person in a given month???

Please it is urgent..

Do sql queries and msaccess queries r equal???
Do sql queries run in msaccess??

select * from person where month(month_fie ld)=month_numbe r

example

select * from person where month(birth_dat e)=3


Do sql queries and msaccess queries r equal??? yes,
Do sql queries run in msaccess? but no all query in sql can run in access