COUNT

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?
 
M

Marshall Barton

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?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top