Gunnar The Query BUILDER does not have a GROUP BY option built it, but the query WIZARD does - click on Query / New and answer YES to the question asking if you want to use the Wizard.
David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "Gunnar Ekblad" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Monday, April 25, 2005 1:02 PM Subject: [RBG7-L] - RE: Query Thanks Dawn I will give it more try But I Just have the impression that I cant make any changes to the where clause it seems to me to be read only! Gunnar Ekblad Kontema IT AB H�stholmsv�gen 32 S-131 30 NACKA 070 545 50 38 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn Oakes Sent: den 25 april 2005 18:47 To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Query Gunnar I always do it at the command line too. But a quick test shows that if you add GROUP BY <columns> to the end of the where clause in the query builder, it works. Dawn -----Original Message----- From: Gunnar Ekblad [mailto:[EMAIL PROTECTED] Sent: Monday, April 25, 2005 12:25 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Query I won't answer my own question, but I did it for my DB from command line and it did work as expected. My preference is actually to do it from command line, but first time I try do a new thing (a new thing for me, not for R:base) I try to do it thru menus. But I still can't find Group By in query builder. If its only me I will drop the subject. Gunnar Ekblad -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Gunnar Ekblad Sent: den 25 april 2005 17:16 To: RBG7-L Mailing List Subject: [RBG7-L] - Query Query Builder. I am trying in my own db to create a query very close to YT3 in RRBYW10 Quote from query defintion FROM InvoiceHeader T35,Customer T9 WHERE T35.CustID = T9.CustID ORDER BY Company ASC GROUP BY T35.CustID,T9.Company But I am missing where I can put the group by clause in the query builder Or do I have to create the query from Command line (or a commandfile)? Gunnar Ekblad
