DCount with Date Grouping

[brunor]

I am using the following textbox to count records within a report group header:
=DCount("[ID]","Query1","[Text] = " & "Text30"), where "Text30" is the grouping criteria and is displayed in the group header. This format works well, but I would like to use something similar to group by month with a [Date] field: =DCount("[ID]","Query1","[Date] = " & "??????").
I have tried multiple variations of syntax without success. Any suggestions would be appreciated.
Thanks.

[June7]

Is Text30 literal text or a field name?

If is text, no need to concatenate:
=DCount("[ID]","Query1","[Text] = 'Text30'")

If is fieldname and text datatype:
=DCount("[ID]","Query1","[Text] = '" & [Text30] & "'")


Use Date/Time functions to manipulation date values. You want to group by month (and I assume also year), extract the Month and Year with: Month([Date]) & Year([Date])

Use the expression as GROUP BY criteria.

The DCount would be like:
=DCount("[ID]","Query1","Month([Date]) & Year([Date]) = some value like 122011")

=DCount("[ID]","Query1","Month([Date]) & Year([Date]) = " & Month([Date] & Year([Date]))

[brunor]

As you suggested, I used this to count the records grouped by month/year:
=DCount("[ID]","Query1","Month([Date]) & Year([Date]) = " & Month([Date]) & Year([Date])).

It works perfectly.
Thank you very much.
BR