<div>
I'm on my iPad, so cannot see what you have done, but for a group footer, you need to configure the report to group by one or more fields. &nbsp;Then makes sure you have the Group Footer turned on, and then insert control(s) in the footer and set their control sources to something like:<br />
<br />
ControlSource: =Sum([Field1])<br />
<br />
HTH<br />
Dale
</div>


<div>
This is very different using code to make the dynamic fields.<br />
The Report Footer fields are created by:<br />
Private Sub ReportFooter4_Print(Cancel<wbr /> As Integer, PrintCount As Integer)<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; Dim intX As Integer<br />
<br />
&nbsp; &nbsp; ' &nbsp;Place column totals in text boxes in report footer.<br />
&nbsp; &nbsp; ' &nbsp;Start at column 2 (first text box with crosstab value). 8/25/16 change intX = 2 to 4 sem<br />
&nbsp; &nbsp; For intX = 4 To intColumnCount<br />
&nbsp; &nbsp; &nbsp; &nbsp; Me(&quot;Tot&quot; + Format(intX)) = lngRgColumnTotal(intX)<br />
&nbsp; &nbsp; Next intX<br />
<br />
&nbsp; &nbsp; ' &nbsp;Place grand total in text box in report footer.<br />
&nbsp; &nbsp; Me(&quot;Tot&quot; + Format(intColumnCount + 1)) = lngReportTotal<br />
<br />
&nbsp; &nbsp; ' &nbsp;Hide unused text boxes in report footer.<br />
&nbsp; &nbsp; For intX = intColumnCount + 4 To conTotalColumns<br />
&nbsp; &nbsp; &nbsp; &nbsp; Me(&quot;Tot&quot; + Format(intX)).Visible = False<br />
&nbsp; &nbsp; Next intX<br />
End Sub<br />
<br />
So I copied the same code to my new grouping and the problem is it is giving me a running total, not &quot;subtotal&quot; for each grouping
</div>


<div>
Report Attached - note the subtotal for &quot;QS&quot; is actually a running total<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w35/1113715/Employee-Sea-Time-Access-Report.pdf" target="_blank" class="file-inline" title="Need subgroup to subtotal, not be a running total (54 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Employee-Sea-Time-Access-Report.pdf</a>
</div>


Need subgroup to subtotal, not be a running total

Employee-Sea-Time-Access-Report.pdf

<div>
again from my iPad, so cannot see your actual data, but if you click on those textboxes in the group and page footer, there is a property {Running Sum) in the Data tab which has options of No, Over Group, and Over All. &nbsp;Set that property to &quot;Over Group&quot; for the group footer controls and &quot;Over Report&quot; for the Report tooter controls.<br />
<br />
Then instead of using the Group and Report footer Print events, use code similar to what you use for the controls on the main form to set the control source of each of the controls to the proper field name, something similar to:<br />
<br />
me.controls(&quot;txt_grp_Col&quot; &amp;&nbsp;x).ControlSource = &quot;[&quot; &amp;&nbsp;me.fields(x).FieldName &amp;&nbsp;&quot;]&quot;'
</div>


<div>
Thanks, I have already played with the Running Sum, no difference with all the different settings (No, over group, over all).<br />
<br />
I am not messing with the code, all the fields are created &quot;on print&quot;: headers, detail and totals. The Access database I attached is the example I used to make my crosstab report dynamic because I have varying start dates for each employee and do not want to hard code any fields.
</div>


<div>
<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w35/1113742/Dynamic-Crosstab-Report---all-fields.jpg" target="_blank" class="file-inline" title="Pic of report - all the fields are unbound and created at run time. (135 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Dynamic-Crosstab-Report---all-fields.jpg</a>
</div>


Pic of report - all the fields are unbound and created at run time.

Dynamic-Crosstab-Report---all-fields.jpg

<div>
I'll have to look at it when I get access to my computer, maybe tomorrow AM.<br />
<br />
I generally set the control source for all of the controls in my dynamic XTab reports in the report load event. &nbsp;At that point, you know all of the columns used and can set those properties once and only once. &nbsp;Then you don't need to mess with them in the Print events, which will slow down the report, especially if you are doing that in the Detail section as well as in the group and page or report footer events.
</div>


<div>
The code I am using does not have anything in the &quot;On Load&quot; of the report. &nbsp;The &quot;On Open&quot; calls out the record set and the variable to hold number of columns in crosstab . &nbsp;The first database is the example I used. &nbsp;I am also attaching &quot;SeaTime.mdb&quot; which has my report. &nbsp;Need to open form &quot;mnuOtherReports&quot; and select an employee to run the report.<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w35/1113754/SeaTime.mdb" target="_blank" class="file-inline" title="SeaTime.mdb (868 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>SeaTime.mdb</a>
</div>


SeaTime.mdb

<div>
Sheila,<br />
<br />
I've been out of town for most of the last week and am trying to catch up. &nbsp;I'll try to get back to this in the next 24 hours.
</div>


<div>
I really appreciate you help
</div>


<div>
smurphy,<br />
<br />
The sample database you provided does not have the same fields as you are depicting in the attached jpg files. &nbsp;I'll try to work with what you gave me.
</div>


<div>
Take a look at what I've done with your report now. &nbsp;I moved all of the formatting of the controls into the form_Open event, changed the column headers to caption controls as well as the Products, Category Total and Totals controls on the left side of the page.<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/09_w36/1114899/RptCrossTab2kModified.mdb" target="_blank" class="file-inline" title="modified report (864 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>RptCrossTab2kModified.mdb</a>
</div>


RptCrossTab2kModified.mdb

<div>
The second database (last attached) attached has the same fields. &nbsp;I will take a look at what you attached right now, thank you for your help
</div>


<div>
sorry, I missed the 2nd database, I saw the two jpg files, does that count for something?
</div>


<div>
JPG was just showing report. &nbsp; I am attaching &quot;SeaTime.mdb&quot;. &nbsp;Need to open form &quot;mnuOtherReports&quot; and select an employee to run the report. &nbsp;I just removed all Event s from each report section and changed the On Open.<br />
<br />
I am trying to implement your change into my SeaTime.mdb I attached but I continue to get errors or Access stops responding. &nbsp;The 2 know differences is the recordsource and parameter which i changed under OPEN event of report<br />
<br />
'''Set qdf = dbsReport.QueryDefs(&quot;A_qry<wbr />SeaTime&quot;)<br />
&nbsp; &nbsp; &nbsp;Set qdf = dbsReport.QueryDefs(Me.Rec<wbr />ordSource)<wbr /> &nbsp; <br />
&nbsp; &nbsp; ' Set parameters for query based on values entered<br />
'''I added for emp name 8/25/16<br />
qdf.Parameters(&quot;Forms!mnuO<wbr />therReport<wbr />s!txtEmplo<wbr />yee&quot;) = frm!txtEmployee<br />
' I also added frm as DIM with On Open<br />
<br />
and <br />
Option Compare Database &nbsp; 'Use database order for string comparisons.<br />
Option Explicit<br />
<br />
' &nbsp;Constant for maximum number of columns EmployeeSales query would<br />
' &nbsp;create plus 1 for a Totals column.<br />
'sem change to 15 8/26/16<br />
Const conTotalColumns = 15<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/09_w36/1114993/SeaTime.mdb" target="_blank" class="file-inline" title="SeaTime.mdb (1.2 MB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>SeaTime.mdb</a>
</div>


<div>
headed out for the evening, but if we have power in the AM, I'll take at look at it then.<br />
<br />
Dale
</div>


<div>
Sounds like you are where i am when it comes to weather. &nbsp;I am in Hawaii waiting for Lester to hit. &nbsp;You must be on the east coast waiting for Hermes . . &nbsp;.
</div>


SeaTimeModified.mdb

<div>
This is excellent - thank you for taking the time to help me.
</div>


<div>
<div class="content wysiwyg-content">
I created my Dynamic Crosstab report and get a total at the bottom of the report but need a grouping total, I pasted the Report Footer code to the Group Footer but it's doing a running total.<br />
<br />
Using example of dynamic form attached . &nbsp;All is working but I need to SUBTOTAL and I cannot get it ito work<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/08_w35/1113590/RptCrossTab2k.mdb" target="_blank" class="file-inline" title="example i used to create dynamic crosstab report.  I need to add in Grouping (784 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>RptCrossTab2k.mdb</a>
</div>
</div>


example i used to create dynamic crosstab report.  I need to add in Grouping

RptCrossTab2k.mdb

I created my Dynamic Crosstab report and get a total at the bottom of the report but need a grouping total, I pasted the Report Footer code to the Group Footer but it's doing a running total.

Using example of dynamic form attached .  All is working but I need to SUBTOTAL and I cannot get it ito work

Dynamic crosstab report - need help on Grouping Total

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.