How to extract month data in query?

[myaccess2000]

Hi,

I have problem in extracting out data entered by user in month in the query. The date is in the short date format and i would like to extract the month data. So what do i need to put in the criteria?

Regards
irene

 

[cmmrfrds]

See thread181-27567

Please, do not post in multiple Access Forums as it will waste the time of the person answering here, since the question has already been answered.