I have created a MS Access 2007 report that includes 6 subreports (subtotals) within it. I was able to use a named field "RowNum" with control source as =1, running sum = Over All and refer "RowNum+1" = RowNumT as subtotal row number (works perfect) for the first subreport1.
However, when referring to subreport1!RowNumT to begin displaying row number is subreport2 I am getting a calculation error.
My goal is to have number 1 to 58 displaying on left side of the report and columns A to P at the top for reference points or guide to the report.
Can this be done having 6 subreports within one report?