COUNT

  • Thread starter Thread starter CORY
  • Start date Start date
C

CORY

I am trying to put an automatic counter at the end of a
report. The counter needs to count a designated field then
add 25% of that, then divide by 8. Is this possible?
 
CORY said:
I am trying to put an automatic counter at the end of a
report. The counter needs to count a designated field then
add 25% of that, then divide by 8. Is this possible?
Click to expand...

It probably is possible, but it's not clear what you mean by
"count a designated field". Generally you count records,
not fields. Maybe you mean to count the records where a
field in the record meets a condition of some kind.

The aggregate function, Count, will return the number of
records where its argument field is not null. If this is
what you want, then the text box expression would be like:

=(1.25 * Count(thefield)) / 8
 
Back
Top