Calculations In Report

R

rohan.berry

Hi there,

I'm struggling to find information on how to use VBA to iterate over
the data in a report to perform calculations on the data. My issue is
that i need to perform calucations row by row that use the Sum of a
column. At the time that it tries to execute the row's calculation, it
cannot know what the sum of this column is going to be. Due to this, i
would prefer to perform the calculations post-load of the report by
using VBA.

Any pointers would be greatly appreciated.
 
C

Carl Rapson

Hi there,

I'm struggling to find information on how to use VBA to iterate over
the data in a report to perform calculations on the data. My issue is
that i need to perform calucations row by row that use the Sum of a
column. At the time that it tries to execute the row's calculation, it
cannot know what the sum of this column is going to be. Due to this, i
would prefer to perform the calculations post-load of the report by
using VBA.

Any pointers would be greatly appreciated.
Click to expand...

I don't think there's any way within a report to perform calculations like
that after the report is finished loading. Assuming the report is based on a
query, you could open a recordset using that query and perform your
calculations. This would be completely independent of the report. You can
use DSum against the same query to get the sum of a particular column.

Carl Rapson
 
C

Chuck

Hi there,

I'm struggling to find information on how to use VBA to iterate over
the data in a report to perform calculations on the data. My issue is
that i need to perform calucations row by row that use the Sum of a
column. At the time that it tries to execute the row's calculation, it
cannot know what the sum of this column is going to be. Due to this, i
would prefer to perform the calculations post-load of the report by
using VBA.

Any pointers would be greatly appreciated.
Click to expand...

Do you mean a rolling sum?
 
Top