DCount and Problem with month function

[omaggi]

Hi Everyone.
I tried to use DCount but I have some problems with the function "month".

I wrote this code:
pippo = DCount("*", "valori15min", "[id_puntoMisura] =" & Me.ccPuntoMisura & " and [id_obis] =" & Me.txtObis1 & " and month[data_ora] =" & Me.ccMese)

But I have problems with the "month".

I need to make this function on the field "data_ora" in my db-table and after check with the value that is contained in ccMese on my form.

Any Suggestions?

Thanks a lot, greetings.

 

[Galaxiom]

Month(someexpression)

The parentheses are essential.

 

[omaggi]

Thanks a lot.
Works greatly!!!

Greetings.