B
BECAM
I have a main report containing 3 subreports. Each subreport is based on a
separate query and has a number of fields, with 5-10 record entries in each
subreport. I need to sum each line of the 3 subreports. That is, i need to
sum the first record on each of the 3 sub reports.
If i create a textbox and use the following formula as the datasource
(=Reports![MainReport]![SubReport]![Field].Value) I can get the FIRST record
value, and this works in summing the first values of the subreports. But how
do i reference in the formula to get the second values, then the third values
and so on.
Or more importantly CAN this be done?
separate query and has a number of fields, with 5-10 record entries in each
subreport. I need to sum each line of the 3 subreports. That is, i need to
sum the first record on each of the 3 sub reports.
If i create a textbox and use the following formula as the datasource
(=Reports![MainReport]![SubReport]![Field].Value) I can get the FIRST record
value, and this works in summing the first values of the subreports. But how
do i reference in the formula to get the second values, then the third values
and so on.
Or more importantly CAN this be done?