SQL GROUP BY

Hejsa
Jeg har et lilel problem med group by.

fejl .:
Microsoft JET Database Engine error '80040e21'

You tried to execute a query that does not include the specified expression 'ID' as part of an aggregate function.

kode.:
SQL = "SELECT tblUgensvinder.ID, tblUgensvinder.BrugerID, tblUgensvinder.Uge, tblBruger.ID, tblBruger.Navn,"
SQL = SQL & " tblBruger.Postnr, tblbruger.Email, tblBruger.Alder, tblpostnr.Byen, tblPremie.VinderID, tblPremie.Premie,"
SQL = SQL & " tblpremie.Ugenr, tblQuestion.ID, tblQuestion.Question, tblquestion.Answer, tblQuestion.Uge"
SQL = SQL & " FROM (((tblQuestion LEFT JOIN tblPremie ON tblQuestion.Uge = tblPremie.Ugenr)"
SQL = SQL & " LEFT JOIN tblUgensvinder ON tblPremie.Vinderid = tblUgensvinder.Brugerid)"
SQL = SQL & " LEFT JOIN tblBruger ON tblUgensvinder.BrugerID = tblBruger.ID)"
SQL = SQL & " LEFT JOIN tblPostnr ON tblBruger.postnr = tblPostnr.Postnr"
SQL = SQL & " GROUP BY tblPremie.Vinderid"
SQL = SQL & " ORDER BY tblQuestion.uge DESC"

SQL .:
SELECT tblUgensvinder.ID, tblUgensvinder.BrugerID, tblUgensvinder.Uge, tblBruger.ID, tblBruger.Navn, tblBruger.Postnr, tblbruger.Email, tblBruger.Alder, tblpostnr.Byen, tblPremie.VinderID, tblPremie.Premie, tblpremie.Ugenr, tblQuestion.ID, tblQuestion.Question, tblquestion.Answer, tblQuestion.Uge FROM (((tblQuestion LEFT JOIN tblPremie ON tblQuestion.Uge = tblPremie.Ugenr) LEFT JOIN tblUgensvinder ON tblPremie.Vinderid = tblUgensvinder.Brugerid) LEFT JOIN tblBruger ON tblUgensvinder.BrugerID = tblBruger.ID) LEFT JOIN tblPostnr ON tblBruger.postnr = tblPostnr.Postnr GROUP BY tblUgensvinder.Uge ORDER BY tblQuestion.uge DESC