<div>
Excellent! &nbsp;An extra group level for job number did the trick. &nbsp;Thanks.
</div>


Excellent!  An extra group level for job number did the trick.  Thanks.

<div>
<div class="content wysiwyg-content">
I have a report that shows all invoiced items and not yet billed items for a job. The report is grouped on invoice number within job number. So general layout is:<br />
<br />
report header<br />
<br />

<div class="indent">
job header <br />
<br />

<div class="indent">
invoice header<br />
<br />

<div class="indent">
invoice item detail
</div>
invoice footer (showing invoice totals)
</div>
job footer - including sub report of unbilled items for this job plus job totals
</div>
report footer (showing grand totals for all jobs)<br />
<br />
The subreport mentioned needs to come after all invoices for current job, and before job totals. &nbsp;It details all not yet billed items for current job.<br />
<br />
Immediately after this subreport the job footer also shows job totals, including totals collected in the unbilled items subreport. &nbsp;These are gathered in global variables.<br />
<br />
My problem is that the job footer format event is triggered BEFORE the subreport is formatted and so the unbilled totals are need are not calculated yet.<br />
<br />
Any ideas of how I could manage this?<br />
<br />
Thanks.
</div>
</div>


I have a report that shows all invoiced items and not yet billed items for a job. The report is grouped on invoice number within job number. So general layout is:

report header

job header 

invoice header

invoice item detail
invoice footer (showing invoice totals)
job footer - including sub report of unbilled items for this job plus job totals
report footer (showing grand totals for all jobs)

The subreport mentioned needs to come after all invoices for current job, and before job totals.  It details all not yet billed items for current job.

Immediately after this subreport the job footer also shows job totals, including totals collected in the unbilled items subreport.  These are gathered in global variables.

My problem is that the job footer format event is triggered BEFORE the subreport is formatted and so the unbilled totals are need are not calculated yet.

Any ideas of how I could manage this?

Thanks.

Access report with subreport

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.