How hide duplicate values in a group header on a report

Is there a way to hide duplicate values in a text box on a report group header?  I've tried hide duplicates = yes in the field properties but the value keeps repeating and displaying.
SteveL13Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
If they truly are duplicates, it is best to get rid of them in the query by doing a group by.  If what you are trying to do is to make a report more readable by highlighting what records go together, setting the hide duplicates property will hide values that are identical to their predecessor.  

If that isn't working, try posting a picture of how that section of the report looks and how the control properties are set.
0
Jeffrey CoachmanMIS LiasonCommented:
<Is there a way to hide duplicate values in a text box on a report group header?>
Then you will have to explain what you are displaying in your group header.
Typically the Group Header contains header information
So if you Group by Employee, the Employee name only prints once,
...Group by Country, and the Country will only appear once.

Not sure what field you have there that will repeat...?

This is why it is always helpful if you include an example of the issue.

JeffCoachman
0
SteveL13Author Commented:
See file attached.
Example.jpg
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

PatHartmanCommented:
It's hard to tell from this view but you might not have enough groups.  Looks like Employee and date are part of the same group header and you should have two.  One for the name and the second for the date.
0
Jeffrey CoachmanMIS LiasonCommented:
That is because you seem to have two grouping levels, and the "Date" group is at a higher level than the "name" group.

Swap the grouping order of these fields and see if that fixes it...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
SteveL13Author Commented:
Nice!  Thanks.
0
Jeffrey CoachmanMIS LiasonCommented:
great
;-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.