First, this newsgroup is about Access and ADP - which is a type of database
project created by Access and designed to be a frontend to SQL-Server - and
has nothing to do with Excel; so you should post your question to a
newsgroup dedicated to Excel or to Excel queries if you want a more explicit
answer.

In your case, as far as I can remember, the Microsoft Query engine used by
Excel cannot represent graphically a select query with a Group By statement;
so you will have to exit the graphic mode and switch to the text mode (also
known as the sql mode) in order to enter your Group By statement manually.
After that, you won't be able to manipulate your select statement
graphically anymore and any further modifications will have to be done
manually (for this particular query, of course).  The same rule apply to the
usage of some other sql statements like the UNION statement.

On how to switch to the text or sql mode, I don't remember.  Probably from
the menu or by using the right click of the mouse on either the title bar or
the main body of the Microsoft Query window.

Hou asjebelieft uw ongevraagde zooi bij U

MH

Wilt U vanaf nu stoppen met voor mij onbelangrijke en ongevraagde berichten.

Bij voorbaat dank  A Buijs.