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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.....
 
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.
 
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.
 
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....
 
<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?
 
THANK you, after working with my SQL view, I was able to correct my problem...

Thank you again
 
Back
Top