SELECT DISTINCTROW Partition([NazivFirme], 0, 50, 5) AS Range,
Count(Klijenti.NazivFirme) AS [Count]
FROM Klijenti
GROUP BY Partition([NazivFirme], 0, 50, 5);
...technicalitiesThat field contains numbers so the data type should be ...?
SELECT DISTINCTROW Partition([broj],1,500,5) AS Range, Count(Test.broj) AS [Count], Test.nazivfirme
FROM Test
GROUP BY Partition([broj],1,500,5), Test.NazivFirme;
The expression you entered contains invalid syntax.
You omitted operand or operator, you entered invalid character or coma, or you entered text without surrounding it with quotation marks.