How to display the records found in selected month?

[JCel]

Hi there!

In my appln, im using 2 combo boxes- one for month and the other for year.
And in my DB table i have fields containing date(Date/Time-Format dd/mm/yyyy) and Names(Text).

Now, I want to get the count of records found in the month and year which i select dynamically!

eg.

I have 10/10/09-Peter; 11/10/09- Mike; 01/11/09-Andrew;
Now if the selected month is Nov 09 then it should display count=1;

Thanks and Regards,
JCel

 

[Hack]

Are you doing this in Access VBA or VB.NET?

 

[rcombs4]

Take a look at the SQL keywords MONTH and YEAR.