Calculations of a field in a form 1

[kschomer]

I have created a form where I would like to count records from a table based on a criteria. I want to do a headcount from a personnel table. ie.
FORM:
field=Customer Support Rep. Unbound field=Count(Title)="CSSR"
field=OrderProcessing Unbound field=Count(Title)="OP"
etc.
TABLE: Last name, first name, title (which includes individuals with Title=CSSR or OP etc.

What is the syntax I need to use for the results of the field in the form be the calculation of the title in the table???

 

[JerryDennison]

You could use DCount("[FieldName]", "TableName", "CriteriaField = 'Criteria'&quot

 

[kschomer]

Thanks Jerry the DCount seems to work out fine. I appreciate your RAPID response. Thank you, Karen