DCount for Multiples

[Huddle]

I am wanting to do a DCount with two variables. I am pulling the data from a Query that filters all the outstanding items. In the D count I want to show a count of the 'Alarms' from 'Jan'. I could do individual queries but I thought I could do it this way (I have 6 systems with 12 months each and was going to change the system and month for each field). Please let me know what my equation is missing.



=DCount("[System]","Q_Metric_System_Breakdown","[System]='Alarm'")&("[Month]","Q_Metric_System_Breakdown","[Month]='Jan'")

[ajetrumpet]

i don't know if two vars will work, but try this:

=DCount("System","Q_Metric_System_Breakdown",

"[System]='Alarm' AND [Month]='Jan'")

the date field has to be a string though.

[Huddle]

Didn't work. I got a #Error as a result