Count Of Field in a Form

[BillBee]

Is it possible to have a count of field in a text box on a Form. I am trying without success and keep getting "#Name?" in the text box. I am using the =[CountOfFieldName] as the Control Source and the text box is in the Form Footer. The Field (Type is Number)is not used on the Form but is in the Query the Form is based on. The Form itself has a combo box where I can select an Exhibitor. A subform will display the Entries for the Exhibitor. I am trying to show on the Form the Total number of entries for all Exhibitors.

 

[PNGBill]

=[CountOfFieldName] Is an Example.

Try =Count([FieldName]) Replace "FieldName" with the actual field name.

Also, the text Box Control must be Unbound

 

[BillBee]

Thanks. That works fine.