Selecting From A N Access Database - Rows Missing

[TompIfe]

Hei,
I have an Access database with a querry containing 40,000 rows.
When I use "SELECT (*) COUNT FROM Querr" in ExecuteScalar, I get only about half of the rows. However, whem I copy the contents of the querry to a Table, a get the full 40,000 number of rows.
Any suggestions?
Best regards,
Tom

[kenobewan]

Try "SELECT COUNT(QuerrID) FROM Querr". HTH.

[TompIfe]

Try "SELECT COUNT(QuerrID) FROM Querr". HTH.

Thanks for your suggestion. I tried it, but it had no effect. I will try to use the same SQL statement that Access uses to generate the Querry. Hopefully, that will work netter.