when I do a select query, using DB Toolkit, I get less data than I expect

[Charlie G]

I run a select query and I want to get test number 271 and above.  The data that is returned begins with test 273 instead.  If I do a query in Access I can see that tests 271 and 272 are in the database.  What can I do to get the right data?

Charlie

[Ben]

The issue as you have described just does not make sense unless the recorders ae not ordered by the test number.

Does the number of records returned match the number in the DB?

Ben

PS: No Mike, you are still the DB guy. Relax.