CASE statement in Query designer - SQL
SELECT
Categorie,
UserID,
(
CASE
WHEN BedragPmnd<0 THEN
BedragPmnd *-1
ELSE BedragPmnd
END) AS total
FROM Begroting
GROUP BY Categorie, UserID