Funcion Suma en Java para la consulta a bd(access)

[hoberwilly]

Xerelo te agradesco:

Lei el link y se supero ese error
*******************************************
GROUP BY More Than One Column

We can also use the GROUP BY statement on more than one column, like this:
SELECT Customer,OrderDate,SUM(OrderPrice) FROM Orders
GROUP BY Customer,OrderDate
*******************************************

Ahora mi trabajo es poder imprimirlo esa SUMATOTAL, lo trabaje de esta manera y no me funca:

r6=s6.executeQuery("SELECT estpago,feccrepago,SUM(monpago) AS sumapagos FROM Pago WHERE estpago = '1' AND FORMAT(feccrepago,'ddmmyyyy') = "+fechaok+" GROUP BY codpago,estpago,feccrepago,monpago");
System.out.println("SQL6 A BD...OK");
while(r6.next())
{
System.out.println("Sum of pays: "+ r6.getString("sumapagos"));
}

esto me imprime:

SQL66 A BD...OK
Sum of pays: 35.0
Sum of pays: 1.0
Sum of pays: 1.0
Sum of pays: 38.0
Sum of pays: 38.0
Sum of pays: 41.0
Sum of pays: 12.0

Pero se requiere imprimir la sumatotal=166


Gracias de antemano