Formula

  • Thread starter Thread starter Christo
  • Start date Start date
C

Christo

Hi There,

Can anyone please help me with the following:

I have a field called reps:

i.e.
James
Jordan
Jordan
James
Ericson
Monroe

and would like to count the number of reps on my report
the answer in this example should be 4 but I cannot seem
to get the formula right!!!!!!

Thanks

Christo
 
Christo said:
I have a field called reps:

i.e.
James
Jordan
Jordan
James
Ericson
Monroe

and would like to count the number of reps on my report
the answer in this example should be 4 but I cannot seem
to get the formula right!!!!!!
Click to expand...


A couple of ways to approach this. One is to use a
subreport based on a Totals query that is in turn based on
the same query the main report is based on. Depending on
how you apply any filtering to the main report, this may be
very easy or rather messy.

Another way is to use Sorting and Grouping to create a group
header and/or footer section for the reps field. Then you
can add a text box named txtRepCount to the header or
footer, set its control source expression to =1 and set its
RunningSum property to Over All. Another text box in the
Report Footer section can then display the number of reps by
using the expression =txtRepCount. This approach might be
straightforward or impossible, depending on what other
sorting and grouping you are using in the report.
 
Back
Top