> I've encountered a most interesting anomaly
> in A2003 Reports. I have a report containing
[quoted text clipped - 17 lines]
> Thanks,
> Bill
Formatting events in reports fire multiple times for lots of reasons. Some
times many more times than just twice. You cannot use these event to reliably
perform calculations.
Usually controls with their RunningSum property enabeled an be used to perfom
such calculations and they don't have the same problems.

Signature
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Bill - 30 Sep 2007 01:49 GMT
Thanks Rick,
I'll keep what you've said in mind for next time. As it
is now, it's easier, for what might very well turn out
to be some throw-away code, to simply track the
RecordID's in the event such they don't get processed
twice. The reason I've never hit this before is because,
as you've already suggested, I use the sum functions
of reports to keep the running totals.
Thanks again,
Bill
>> I've encountered a most interesting anomaly
>> in A2003 Reports. I have a report containing
[quoted text clipped - 24 lines]
> Usually controls with their RunningSum property enabeled an be used to
> perfom such calculations and they don't have the same problems.