 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / January 2006Why do I get Duplicate information in a Report in Access?
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.  SignatureDuane Hookom MS Access MVP -- >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 have 3 tables...... Supervisor, Instructor, and Students.... and they have relationships.... 3 out of 5 reports are OK... but 2 have duplicates.... Thank you.... > 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 [quoted text clipped - 6 lines] > > or I will have to create another database, because I am not able to fix > > it..... <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? SignatureDuane Hookom MS Access MVP -- >I have 3 tables...... Supervisor, Instructor, and Students.... and they >have [quoted text clipped - 15 lines] >> > or I will have to create another database, because I am not able to fix >> > it..... THANK you, after working with my SQL view, I was able to correct my problem... Thank you again > <tongue in cheek> > Instructors shouldn't have relationships with students [quoted text clipped - 21 lines] > >> > or I will have to create another database, because I am not able to fix > >> > it..... 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 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..... Thank you... I was able to work my problem out..... > 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 [quoted text clipped - 10 lines] > > or I will have to create another database, because I am not able to fix > > it..... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.