Solved

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

Posted on 2012-12-21
5
481 Views
Last Modified: 2013-01-07
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
0
Comment
Question by:Karen Schaefer
5 Comments
 
LVL 8

Expert Comment

by:Barry62
Comment Utility
can you post the vba code?
0
 
LVL 9

Expert Comment

by:borki
Comment Utility
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?
0
 
LVL 29

Expert Comment

by:IrogSinta
Comment Utility
Set the Hide Duplicates property of those fields to True.
0
 

Accepted Solution

by:
Karen Schaefer earned 0 total points
Comment Utility
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.
0
 

Author Closing Comment

by:Karen Schaefer
Comment Utility
t
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now