Query not showing all entries

[HeadGasket]

Got the meat and potatoes of my database working but now as far as tables and forms go, but now I would like to start working with queries and reports. I'm having some difficulty with one query in particular.

The query is called Query_NCEvents_By_Employee and if it did what I want it to, it would return all Non-Conformance instances by employee. But, it is leaving out a few records and I don't know why. I don't have any criteria stated that would block some records. I think it is related to my Table_Employees and Query_Employees but I'm not sure.

The query is leaving out records (NCID) #3 and #4.



I don't know how to explain the issue concisely enough for this post so I have attached some screenshots and the database. If you open the Form_NCEventMain you can cycle through the records. The sub-form is where the data is that I would like to query.

Thanks in advance.

Attachment 6212

Attachment 6213

Attachment 6214

[aytee111]

I deleted Table_Disposition from the query and records 3 and 4 showed up. That is where your problem is.

[HeadGasket]

Thanks, aytee111.

Just curious how you figured that out. Was it trial and error or did you see something wrong?

Also, would you happen to know why that table was causing an issue when there are three other similar tables that are not causing any problems?

-David

[aytee111]

Ha, I nearly died when I opened the query and saw all the tables linked! I was too lazy to go through them one by one so thought I would first do the delete thing and see if that showed me the problem. It did.

That table is causing the problem because on Table_NCEventSub1 the DispID is null and therefore cannot link to the Disp table. If you want to keep it as is, then change the link between the two tables (click on the link, right-click, join properties) and change it to include all records from table A regardless of whether the join to table B works or not.

[HeadGasket]

Ha! Probably has rookie written all over it. Time for me to take a class on Access.

Thanks, again. Case closed.

[aytee111]

Actually I was very impressed - that takes courage!