Group by - part of a field

If I understand right the car number is something like 5.32 and you want to group by that number but sometimes you want to just by 5.3 ? as there are cars called 5.31  5.32  5.33 and so forth? Let me know if that is what you want to do!

Well you got a little problem there I think. If you'd use SQL Server you could just execute something like
select carid from table
group by left(carid,3)
this unfortunately does not work in access though. I would create an extra field in access and just enter the part you need for that grouping or create a temp table, select everything into there using left  (assuming the carid is always below 10 otherwise use another function) and then query that temp table. Let me know if you get stuck doing that... 

That is why I said if there are double digitnumber in there you shoulduse seomthing like formatnumber() or so.