The following is a query run on SQL Server, it shows different records and total 204 records.
I use Linked Table Manager to link to the table _QryDispenHistory, it shows 204 records, but they are all the same as below
Actually, I use Linked Table Manager to link other tables from SQL Server, they are all correct.
How can I fix it?
Thanks