Bonjour les infomaticiens

Bonjour,

je voulais faire une requete qui me permet d'afficher nom d'utilisateur,type de paiement ,id..,je voulais faire la somme suivant le type de paiement

voila ma requete


SELECT CASH_CHECK.CHECKNUMBER,CASH_CHECK.CLEARCOSTALL,CASH_CHECK.PAYMENTCOST,
CASH_CHECK.COSTALL,CASH_PAYMENTS.[NAME],USERS.NAME,DBO.DateToDateStr (CASH_CHECK.CREATIONDATETIME)
FROM CASH_CHECK

JOIN CASH_PAYMENTS ON CASH_PAYMENTS.id=CASH_CHECK.PAYMENTTYPE
JOIN USERS ON USERS.ID=CASH_CHECK.USERID
WHERE


CASH_CHECK.[ENABLED]=1

and

CASH_CHECK.ISRETURN=0


AND
floor(CASH_CHECK.CREATIONDATETIME) >= dbo.DateStrToDate('02/12/2013 00:00:00')
AND floor(CASH_CHECK.CREATIONDATETIME) <= dbo.DateStrToDate('02/12/2013 23:59:59')



ORDER BY CASH_PAYMENTS.[NAME],CASH_CHECK.CHECKNUMBER