Please note: my copy of Access is in Dutch, so any English parts are translated from Dutch.

I'm currently working on a database in Access using SQL, with the exercise being:

Create a query that will list all students who have more than €25 of penalty.

I created this query:

SELECT LEERLINGEN.LLNR, UITLENINGEN.LLNR, LEERLINGEN.VOORNAAM, LEERLINGEN.TUSSENVOEGSEL, LEERLINGEN.ACHTERNAAM, SUM(UITLENINGEN.BOETE)

FROM LEERLINGEN INNER JOIN UITLENINGEN ON LEERLINGEN.LLNR = UITLENINGEN.LLNR

WHERE (((UITLENINGEN.BOETE)>25));

When I click "Execute", I get the following error (translated from Dutch)

"You are attempting to execute a query in which the selected expression LLNR is no part of a statistical function."

What should I do?

Translations: | Leerlingen = students | Boete = penalty |

Please note: my copy of Access is in Dutch, so any English parts are translated from Dutch.

I'm currently working on a database in Access using SQL, with the exercise being:

Create a query that will list all students who have more than €25 of penalty.

I created this query:

SELECT L.LLNR, U.LLNR, L.VOORNAAM, L.TUSSENVOEGSEL, L.ACHTERNAAM, SUM(U.BOETE)

FROM 
    LEERLINGEN L
    INNER JOIN UITLENINGEN U ON L.LLNR = U.LLNR

WHERE (((U.BOETE)>25));

When I click Execute, I get the following error (translated from Dutch)

You are attempting to execute a query in which the selected expression LLNR is no part of a statistical function.

What should I do?

Translations: | Leerlingen = students | Boete = penalty |