Mysterious Recordset Changes

B

BCP

Recently I ran a query, the query had a join between two table. One of the
joined tables was set up to restrict the result set of the query. This
joined table only contained one row of data. When I ran the query it had
1066 rows of data. This looked like way too many records. I resorted the
data by one of the unique keys to look for duplicate rows and the recordset
went from 1066 rows to 360. This happend in the datasheet view, I did not do
a requery. How is this possible and why would the query results change just
because I resorted the datasheet view of the data.
 
J

John Nurick

Hi,

I suggest you ask the question again in the Queries newsgroup
(microsoft.public.access.queries). When you do, open the query, switch
it to SQL view, and paste the SQL of the query into your message. That
will make it much easier for people to help.
 
Top