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

Karen Schaefer
Karen Schaefer used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
can you post the vba code?

Commented:
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?
Set the Hide Duplicates property of those fields to True.
BI ANALYST
Commented:
I changed what data gets updated into the temp table - which is the source of data for the org chart.  Thanks for the input.

Found solution  - by rewriting the query.
Karen SchaeferBI ANALYST

Author

Commented:
t

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial