Why label in group header shows up duplicated on first page

got_access:]

Registered User.
Local time
Today, 14:11
Joined
Jun 15, 2018
Messages
83
Hi,
I am new to Access and especially to reports.
I've noticed when creating a report with a group, when I add a label along side the control field which is bound to the group data value, that label appears twice on the reports first page. It is displayed within the group header section and also above it, in the page header.

Also, simply changing this group control field's border from translucent to solid produces the same result. On the first page only, it displays this both within the group header and above within the page header.

I would like to understand why Access is doing this.
Hope I explained so that its understandable.
Thanks!
 
I have a table containing all of Excel’s functions - with their descriptions grouped in their categories. The report is to be a listing of these functions grouped by category.

The attached picture shows 4 screen-shots.
The 1st and top pic shows the result of the default report via the wizard where the report is grouped by category.

Within the page-header section you can see the default labels “Category”, “Function” and “Description”. Under that is the default group header, with the control field that displays “Category”.

The 2nd pic shows the design view – at this point with no alterations.

I remove the three labels within the page header and close-up that section.
Then I move the “Category” control field into the center of its group header section.
Then I locate a label to the right of it with the word “Functions”.
The 3rd pic shows this change in the design view

The 4th pic shows the word “Functions” is printing twice.
But it only does that on the first page.
It appears to be printing within the page header section.
 

Attachments

  • AccessReport.jpg
    AccessReport.jpg
    101.5 KB · Views: 154
Awesome! That was it.
Ok now I'm curious what tipped you off that it would be a blank record in the table?

And I'd really like to know what logic is going on in the report sections to make it do that.

Thanks!!! :-]
 
The good part is I usually remember the solution once I understand what caused the problem.

For me, the direct opposite applies. And as Billy Joel has said “Things I didn’t know at first, I learned by doing twice”, or three, four...

In all seriousness, I get dismayed and sometimes even discouraged sometimes at how many times I have to retrace my steps. I have even looked into some concepts like the “Memory Palace”, but with marginal results.

Could be all the red wine that seems to be the dietary staple over here...
 
Ah! I get it! Yes - I should have thought of that.
Thanks very much for your help! :-]
 

Users who are viewing this thread

Back
Top Bottom