Try this
SELECT regRaport.regRaport_id,
regRaport.regRaport_date,
regRaport.regRaport_soldinitial,
regRaport.regRaport_soldfinal,
IIF(regRaport.regRaport_categorie Is Null, 0, regRaport.regRaport_categorie) AS RegRaportCategorie
FROM regRaport
inner join (select regRaport.regRaport_id as ID,
MAX(regRaport.regRaport_date) as regDate
from regRaport
WHERE regRaport_categorie = 5) reg
on regRaport.regRaport_id = reg.ID
and regRaport.regRaport_date = reg.regDate