Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2012-12-21
5
488 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
ID: 38714638
can you post the vba code?
0
 
LVL 9

Expert Comment

by:borki
ID: 38714668
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
ID: 38714906
Set the Hide Duplicates property of those fields to True.
0
 

Accepted Solution

by:
Karen Schaefer earned 0 total points
ID: 38738053
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
ID: 38750299
t
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

808 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