Why do I get Duplicate information in a Report in Access?

R

Ro

I have different queries, with relationships. When I create a report I get
some employees more than once (4 times). I know that my information is
inputed only once.... HOW can I fix my problem.... I need to fix this ASAP
or I will have to create another database, because I am not able to fix
it.....
 
D

Duane Hookom

I expect your query includes a table that has the employee related value 4
times. This generally expected. If you can't figure this out, reply with
information about your tables, key fields, and your SQL view of your query.
 
P

Pat Hartman\(MVP\)

As Duane already pointed out, you are joining tables that have a 1-many
relationship. I find the best way to handle this in a report is to create a
main report that displays data from the 1-side or parent table and a
subreport that displays the data from the many-side or child table. An
alternative that may work for you is to add group headers using the sorting
and grouping dialog. That will eliminate the "duplication" of the 1-side
data.
 
R

Ro

I have 3 tables...... Supervisor, Instructor, and Students.... and they have
relationships.... 3 out of 5 reports are OK... but 2 have duplicates....

Thank you....
 
D

Duane Hookom

<tongue in cheek>
Instructors shouldn't have relationships with students
</tongue in cheek>
Would you mind sharing anything about the tables, the relationships, etc?
How about the SQL view of your query?
 
R

Ro

THANK you, after working with my SQL view, I was able to correct my problem...

Thank you again
 
Top