DCount criteria

Hi,

When using the DCount function it counts the criteria for all the records. I want it to be limited to count for a specific value in a field.

My current build looks as followed:
AutoCountBE25: DCount("[POrg]='BE25'";"[Automation Ratio - Purchasing organisations BE25 and BE05]";"[Auto/Man]='auto'")

As you can see in the attached Datasheet View it still counts "auto" for all the records instead of those for BE25 in the POrg field. AutoCountBE25 and ManCountBE25 should total BE25Count.