Not all records appear in my form

[aprilbernard]

I have created a form to display records for folks to look at and update. However, I have noticed that not all records are being displayed. 13 records out of 114 are being left out. Can someone help, please? I've looked at my relationships, checked for missing data that connects tables, etc.

 

[ott]

The recordsource for this form is a query? And if so, when you run the query does it display all of the desired records? Is there a logic problem with the query?

If this isn't the case then give a few more details and let's see if we can figure it out.

 

[aprilbernard]

Not all records appear in my query, as well. This is confusing to me, because the query is, basically, a listing of all my fields. I checked the table to make sure that all appropriate entries were made. Everything seems ok.

 

[ott]

Are there linked tables in your query?

Post the SQL statement for the query and let's have a look.

 

[aprilbernard]

This is the sql statement, it's long. There are several tables with relationships, too: SELECT tbl_Applications.AppNo, tbl_Applications.cSchDistNum, tbl_Applications.Y1App, tbl_Applications.Y2App, tbl_Applications.TotalApp, tbl_Applications.Y1Funded, tbl_Applications.Y2Funded, tbl_Applications.TotalFunded, tbl_Applications.PupilCnt, tbl_Applications.Consortium, tbl_Applications.SchoolCnt, tbl_Applications.Funded, tbl_Applications.Notes, tbl_Applications.CFName, tbl_Applications.CLName, tbl_Applications.Phone, tbl_Applications.Fax, tbl_Applications.Problems, tbl_Applications.Email, tbl_Applications.SubApp, [TBL Combined SchDist].cName, [TBL Combined SchDist].cAddress, [TBL Combined SchDist].cCity, [TBL Combined SchDist].cSt, [TBL Combined SchDist].cZip, [TBL Combined SchDist].cPhone, [TBL Combined SchDist].cFax, [TBL Combined SchDist].cRegionCode, [TBL Combined SchDist].cGrades, [TBL Combined SchDist].cDistNum, [TBL 2 District Master].rd2DistName, [TBL 3 Region Master].r3Name, tbl_Applications.Score
FROM [TBL 3 Region Master] INNER JOIN ([TBL 2 District Master] INNER JOIN (tbl_Applications INNER JOIN [TBL Combined SchDist] ON tbl_Applications.cSchDistNum = [TBL Combined SchDist].cSchDistNum) ON [TBL 2 District Master].rd2DistNo = [TBL Combined SchDist].cDistNum) ON [TBL 3 Region Master].r3Number = [TBL 2 District Master].r3Number
ORDER BY tbl_Applications.AppNo;

 

[Pat Hartman]

Inner joins require a particular key to exist in both tables being joined. At least one of the tables is missing the 13 records you have lost. If that is valid, changing the join(s) to LEFT rather than Inner should solve the problem. If the data is "required" to be in each table, you have some other problem and need to fix the data. You should also identify which process is causing the data anomoly and fix it to prevent future occurances.

 

[aprilbernard]

Thanks! I'll check the joins and look at the tables.