Linked table returning wrong query values

M

Melchior

I have a user who is using an access 2003 database to query a SQL server
through an ODBC connection. The table they are trying to hit has over a
million rows of data in it. When the query is run, it returns the correct
number of rows of data it should, but it is pulling the completely wrong
rows, however when the totals button is clicked (even though there is nothing
to total) and then the query is run, it returns the correct data. What could
be causing this?
 
Top