Access Function that counts records with specified criteria?

[Blazin J]

I have an Access 2007 database that has two related tables (let's call them [PARENT] and [CHILD]). I have created a form that shows the fields of the [PARENT] table and below an embedded subform that displays the fields of the related [CHILD] table.

One of the text fields in the [CHILD] table is called "Status". The status can contain various values (e.g., "Ready", "Waiting", etc.)

I want to create an unbound textbox on this form that displays the number of records in a "Ready" status. What is the syntax of function that will accomplish that?

Thanks in advance for your help!

 

[Joe4]

Take a look at the DCOUNT function: MS Access: DCount Function

 

[Blazin J]

Thank you, Joe4!