Calculations In Report

  • Thread starter Thread starter rohan.berry
  • Start date Start date
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.
 
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
 
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?
 
Back
Top