<div>
Can you take a screen shot of the report in design view, showing the grouping and sorting at the bottom of the report designer as well?<br />
<br />
Also might be helpful to see the query that is the Recordsource for the report. &nbsp;<br />
<br />
Sample database would be even more helpful, if possible
</div>


Can you take a screen shot of the report in design view, showing the grouping and sorting at the bottom of the report designer as well?

Also might be helpful to see the query that is the Recordsource for the report.  

Sample database would be even more helpful, if possible

<div>
Make sure the master/child links are set correctly for the subreport.
</div>


Make sure the master/child links are set correctly for the subreport.

<div>
I discovered the solution before anyone else suggested it.
</div>


I discovered the solution before anyone else suggested it.

<div>
<div class="content wysiwyg-content">
I am designing a report in Access 2007, based upon a query.<br />
The first group is based upon a date field (TransferDate).<br />
I have defined a second group (a sub-group) &nbsp;which is based upon an expression, which is 3 string fields concatinated.<br />
Finally there is a detail section which displays data from each record.<br />
<br />
When I run the report, I expected all the detail records in the subgroup to have the same TransferDate.<br />
Not so! &nbsp;I get just one TransferDate group, and each subgroup has detail records with various TransferDates.<br />
<br />
What am I missing?<br />
<br />
(I am an experienced programmer, but have not worked much with Access Reports.)
</div>
</div>


I am designing a report in Access 2007, based upon a query.
The first group is based upon a date field (TransferDate).
I have defined a second group (a sub-group)  which is based upon an expression, which is 3 string fields concatinated.
Finally there is a detail section which displays data from each record.

When I run the report, I expected all the detail records in the subgroup to have the same TransferDate.
Not so!  I get just one TransferDate group, and each subgroup has detail records with various TransferDates.

What am I missing?

(I am an experienced programmer, but have not worked much with Access Reports.)

access reports

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.