Calculations In Report

[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.

 

[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.

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

 

[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.

Do you mean a rolling sum?