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
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.
K
Microsoft DevelopmentMicrosoft Access
Last Comment
Karen Schaefer
can you post the vba code?
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?
Have you thought of making the column 1 data field visible=false?
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
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
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 questionASKER
t