Try the help on Datepart(m,datefield).....

Try using this in WHERE clause of ur query. This should solve.

Cheers!!!
Vijay.G
 Imran wrote:Greetings
I'm wondering if I could only query by the month. I just want to output 
the query according to the month,like, for example :

Table name : CustomerTable

CustomerID EmailAddress Date
123 123@s... 12/6/02
141 141@s... 4/6/02
287 287@s... 7/6/02



I just want to display the customerID according to the month, and in the 
above case, for the month of June.
Is it possible? Any help will be highly appreciated. Thanks. :)


---------------------------------
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes