Replies

I resent MS forcing us to ‘upgrade’. I detest Win 8 — gave away the laptop I bought having it.
It’s all about maintaing the revenue stream.
Win 7 forever with good protection software.
And I feel better getting that off my chest.

Create a label in the Group Footer — lDays in this example

Click on the Group Header, add an Event Procedure for On Format with this code (Access adds the Sub and End Sub lines:
Me!lDays.Caption = “”

Click on Detail, add an Event Procedure for On Format with this code:
Me!lDays.Caption = Me!lDays.Caption & ” ” & [Day] (where [Day] is your data field name or text box displaying it)

That’s all!
Each time the group header changes, the label is cleared.
Each time a new detail is prepared for display, the Day is appended to the label.
The label automatically displays as part of the Group Footer.

If you want to use a text field rather than a label, you can accumulate the days in a variable, then set the field = variable in the Group Footer On Format.