help me correct my error for Count function

azhar2006

Registered User.
Local time
Today, 03:56
Joined
Feb 8, 2012
Messages
292
Hello my dear friends
I am trying to use the (Count) function to collect the number of employees, but I get an error
The employees table is in a subform and I am trying to use an unstructured field based on this expression, but I encounter an error in writing the expression below
=Count([sfrmForm]![fullname])
Please help me correct my error
 
Where is this textbox located - on main form?

Do this calc in subform header or footer section: =Count(*)

Then textbox on main form can reference textbox in subform:
=subformcontainername.Form.textboxname

Yes, must be .Form exactly as shown.
 
Where is this textbox located - on main form?

Do this calc in subform header or footer section: =Count(*)

Then textbox on main form can reference textbox in subform:
=subformcontainername.Form.textboxname

Yes, must be .Form exactly as shown.
Yes the text box is located on the main form
 

Users who are viewing this thread

Back
Top Bottom