Follow up to prior posting (execution speed)

[Shell]

I created a pass thru query to SQL SVR. When I run the query as is for a set
of given criteria I get 4000 records.

When I use this Pass thru query as an input to to a MakeTable query I get
4000 records.

BUT, when I use this Pass thru query as an input to an append query (on an
empty table) for execution speed comparisons against the Make Table query, I
get 4012 records. With difficulty I was able to isolate the 12 extra records
and found no commonality.

Does anyone have a suggestion as to why the discrepancy and to what I can do
to correct the problem?

Thanks

 

[bhicks11 via AccessMonster.com]

I don't Shell but maybe if you post the SQL some of the smart guys will look
at it.

Bonnie
http://www.dataplus-svc.com

 

[John W. Vinson]

I created a pass thru query to SQL SVR. When I run the query as is for a set
of given criteria I get 4000 records.

When I use this Pass thru query as an input to to a MakeTable query I get
4000 records.

BUT, when I use this Pass thru query as an input to an append query (on an
empty table) for execution speed comparisons against the Make Table query, I
get 4012 records. With difficulty I was able to isolate the 12 extra records
and found no commonality.

Does anyone have a suggestion as to why the discrepancy and to what I can do
to correct the problem?

Thanks

Correct the error in your query. If you would like help doing so please post
the SQL of the query and indicate something about the structure of the data.
We can't help with a problem that we cannot see!