Dcount with two criteria

[syedadnan]

Regards,

I have a field named Poisition_Id and a yes/no field with the name Hired, what i want is dcount under condition initially with Position_ID to Position_ID then to see the field of hired if "yes"

Example:

=dcount "a" see in tbl_open with criteria position_id = position_id with criteria hired=yes

i am unable to write this formula.. plz guide ...

 

[JLCantara]

Read this:
https://msdn.microsoft.com/en-ca/library/office/ff191865(v=office.15).aspx