I have the following control souce for a text boxt that I just can't seem to get to function correctly :
=DCount("[Facility]"," qry_Placement ","[ Facility] = 'Denied' And [AdmitFacility] <> ' Non-Collaborative Facility'")
Essentially I would like to have the database find the Facility field in qry_Placement where the field is equal to Denied and where the AdmitFacility field is equal to Non-Collaborative Facility. All the fields I am working with are text only. I'm not sure what I'm doing wrong.