SQL forespørgsel - gruppering

NOTE when we use GROUP BY the text field fremmedeordrenr will more than likley be different so we CAN NOT GROUP on that field otherwise you will get one line per record. So in this example i jsut select the first text.

SELECT tabel.egetordrenr, tabel.klartillevering, First(tabel.fremmedeordrenr) AS FirstOffremmedeordrenr
FROM tabel
GROUP BY tabel.egetordrenr, tabel.klartillevering
HAVING (((tabel.klartillevering)=True));

smart...