DCount in Access 2010 Query

[time2hike]

Hi, I have a query that pulls in hours for multiple Subprojects by Month and Year. To be able to compare data I need to Count the Month & Year for each subproject. Example Subproject1 11/2011 would be 1, Subproject 1 12/2011 would be 2, and Subproject2 3/2009 would be 1. So, I am trying to use a DCount in an Access 2010 query. This is my SQL:

SELECT qLbrEstModelBaseHours.SUBPROJECTID, qLbrEstModelBaseHours.FISCALYEAR, qLbrEstModelBaseHours.ACCOUNTINGPERIOD, qLbrEstModelBaseHours.FiscalYearMonth, CInt(DCount("FiscalYearMonth","qLbrExtModelBaseHours"," FiscalYearMonth <=" & [FiscalYearMonth])) AS [Month]
FROM qLbrEstModelBaseHours
GROUP BY qLbrEstModelBaseHours.SUBPROJECTID, qLbrEstModelBaseHours.FISCALYEAR, qLbrEstModelBaseHours.ACCOUNTINGPERIOD, qLbrEstModelBaseHours.FiscalYearMonth;

I am getting a #Error instead of a count. I have attached a snapshot of my results.
Can you tell me what I am doing wrong?
Thank you for your assistance.

[Rabbit]

I'm pretty sure DCount is the wrong way to go with this but you're not really clear on what it is you're trying to do.

Anyways, the problem is that in one place, you call it qLbrEstModelBaseHours, but in the other, you call it qLbrExtModelBaseHours. One of them is wrong.

[NeoPa]

Rabbit's second paragraph is the answer to your question, but their first is far more important. If you're clever you'll pay more attention to that the just the quick fix to the runnability of the query ;-)

[time2hike]

Rabbit, thanks for finding my typo. I hear you about the DCount not being the solution. I will start a new thread and try to better explain what I need to do.