Query acting strange

[rtshort]

This may belong in the Access forum but I'm not sure.

I have the following query and use Access 2000. The query is ran in a VB Program. I've tried to run it in Access itself and get the same results though.

SELECT DISTINCTROW Max([Client].[ID]) AS ID
FROM Client;

It works fine until the ID number gets past 10. Once it gets past 10, the result always comes back 9.

What am I missing here?

Rob
Just my $.02.

 

[rtshort]

After a day of pulling my hair out before posting my problem here, it finally HIT ME square in the head.

I had the ID field set to "text" and not "number". I was looking over it for the 1000 time when I noticed it.

Maybe this will help some other poor soul such as myself one day.

Thanks guys

Rob
Just my $.02.