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.)