Avatar of Karen Schaefer
Karen Schaefer
Flag for United States of America asked on

Access Report - Prevent duplicate data being displayed (Org Chart)

I am creating an Organization Chart using an Access Report to be exported as a PDF.

The report has a Header w/Sub header.  The header consist of the Unit chiefs Name & Title, and Org Name.

The sub Header has the Office Assistants (OA) Name.

My current report is made up of Columns and my current version wants to redisplay the Unit Chief and OA information in the first column - How do I prevent this from being displayed multiple times.

OrgSample
K
Microsoft DevelopmentMicrosoft Access

Avatar of undefined
Last Comment
Karen Schaefer

8/22/2022 - Mon
Barry62

can you post the vba code?
borki

You haven't given us a lot of info, eg the data source of the report and the fields you use in the design of the report.

Have you thought of making the column 1 data field visible=false?
IrogSinta

Set the Hide Duplicates property of those fields to True.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER CERTIFIED SOLUTION
Karen Schaefer

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Karen Schaefer

ASKER
t