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);