DCount .......

[Guest]

Dear all,

I have a form that's used to disply the search citeria,the form looks like
this :
Name Job description phone Mobile
John employee 00 00
Tony Account manager 00 00
Peter Supervisor 00 00

I'd like to creat an unbound text box to count the how many "account manger"
will appear as a result of this searcjing,and another unbound text box to
count how many supervisores.....

Note that i want to count according to the searching results that are
present on the current form.

Regards

Note

 

[Jeff C]

Another way to solve your need would be to base your form on a totals
query that does your counting etc.

 

[Guest]

Can't i do it through the form ? how?

Another way to solve your need would be to base your form on a totals
query that does your counting etc.

 

[Steve Schapel]

Note,

Yes. In the Control Source of the unbound textbox in your form's
footer, put like this...
=Abs(Sum([Job description]="Account manager"))