See attached picture. I've filtered the form by ProjectNo = 28341, but the record that returns has ProjectNo = 16424. I've checked the backend and found two records with the above project numbers and the same address, but I don't see how this could have occurred. When the view is sorted by ProjectNo in MSAccess, the ProjectNo column shows 28342, 16424, 28340, so it appears that MSAccess knows what the correct ProjectNo is and is for some reason refusing to show it.
Any idea what the problem might be?
Filtered view and incorrect result
CodePudding user response：
So, it seems you are using link table or pass-through query. I assume problem is causing due to ODBC driver for SQL Server. Use updated SQL-ODBC driver and problem should solve.
Check from Microsoft Download ODBC Driver for SQL Server.