Quote Originally Posted by jmcilhinney View Post
How can we know what's wrong with your code without seeing it? This seems like a SQL question anyway, so it would belong in the Database Development forum rather than VB. It seems like you should be grouping by month and then aggregating by count. If you are doing this in SQL, you might consider following the SQL tutorial link in my signature below, which should include information on grouping.
Sorry, Im Ussing Ms. Access as Database, heres my code.
Select Count(*) from TblEmployee where str(datepart("yyyy",ExpDate)) +'/'+ str(datepart("m",ExpDate))