Unanswered: Reporting Issue...This should be an easy for anyone comfortable with Access... ;)
Hi everyone! It's Friday!
I have a quick question about getting too many values in my report. I have a report that combines 3 queries based on three tables which have one primary key in common (NCR Num). The only issue is that when I combine them together and run the report, I am getting ALL the entries from the tables, instead of just the entries that are associated with that one common primary key value (NCR Num). This is better explained visually in the reports attached.
Relationships: Shows the three tables and how they relate
Report Layout: Shows how I have done up the report in design layout
Report Results: Shows the extra values that I do not want. Ex. This is the report for NCR 19 but I am getting information for NCR 20 and 21 in the Problem Section and NCR Employee Section
Data Entry Form: Just shows the data entry for that feeds entries into all three tables.
Hopefully there is just something simple that I am missing. I have been stuck on this for 2 weeks now!
Thank you all for your consideration and have a terrific weekend.