I have a report. I want to place the total number of calls but this is
for every 10th record.

So I want the total number of records to show in a textbox in the
report.

For example, I have 7440 records, but counting every 10th record
(every 10th Caller ID) I want the total 744 to show in the box.

I am trying to use the Running Sum on my Report Footer without
success.

I have a query behind the report and the figures I use for percentages
elsewhere on the report are totalled in the query as Min.

I can't figure out how to get my total number of the every 10 records
to be included on this query.

Or is it better to use the Running Sum textbox in the Report Footer?

Thanks,

John

zufie wrote:

Can you create the running sum and set the field (RunSumFld) to
invisible? Then create another variable that's has a control source of
=[RunSumFld]/10

"Salad" <oil (AT) vinegar (DOT) com> wrote

Or, to get a truncated result, use a calculated Control with =[RunSumFld]\10
as its Control Source (and you probably will not even have to set a format).

Larry Linson
Microsoft Office Access MVP