Since you want to treat 767.24 as just 767, the values have to be converted to Integers (?) first, or rounded down to the whole number, so I would try something like:
[tt]
Select DOS, COUNT(CINT(CODE)) AS MYCOUNT
FROM MyTable
WHERE CODE BETWEEN 767 AND 767.99999
GROUP BY DOS[/tt]
---- Andy
There is a great need for a sarcasm font.