Partition with Access SQL

[b82726272]

Hi,

I was wondering if I can use the partition function with Access SQL for a string? The string consists of numbers and plus and minus symbols (for example 6, 7+, 7-). That is the reason it is a string. Now I want to order them in certain categories. I have converted the string to an integer, either I still get the following error: Data type mismatch in criteria expression. Below the code I have used. Thank you for the help.

Kind regards,

Bas

SELECT Abs(CInt(Nz([KLANT_NUMBER], 0))), DISTINCTROW Partition([KLANT_NUMBER],0, 500, 50) AS Range, Count(KLANT_NUMBER) AS Count


FROM KLANT
GROUP BY Partition([KLANT_NUMBER],0,500,50);

[b82726272]

The problem has been solved. I had a string value in my data, after the conversion.

Kind regards,

Bas