Improve company productivity with a Business Account.Sign Up

x
?
Solved

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

Posted on 2012-12-21
5
Medium Priority
?
498 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
This following write-up describes a different way to copy Lotus Notes Calendar to Outlook. Along with this, we will also learn the reason behind this NSF to PST migration. Users can prefer different procedures as per their convenience.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

595 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