Why doesn't this DCount() work?

[tim_tims33]

Hi,

Trying to apply a simple Dcount() to a table to return the number of records WHERE....
(i) The priority Level is High
(ii) The issue is resolved.

Each time i keep getting 0. Why is this?

Here is my table... in the attachment



...and here is my DCount() expression...

=DCount("Fix_ID","Fix_List",([PriorityLevel]="High") And ([Resolved]="True"))

[orange]

Date is a reserved word in Access.
Do not use a naming convention that allows embedded spaces in field or object names.
Do use special characters "/" in field or object names --- will require special handling throughout your application
and will lead to syntax errors.

Untested but I'd try

=DCount("Fix_ID","Fix_List","PriorityLevel='High' And Resolved=True")