Re: SQL Error using 'Name' as field

Hi Pablo, GROUP BY is an aggregate SQL function and must include all fields found in the SELECT clause. SELECT Name, PackageSent FROM location WHERE NOT PackageSent IS NULL GROUP BY PackageSent, Name; I'm performing the following query to an Access database in a page: cfquery

RE: SQL Error using 'Name' as field

NT(*) AS tot_clients FROMClient GROUP BY lname ORDER BY lname /cfquery Duane Boudreau CFExperts.Com -Original Message- From: Pablo Nevares [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 29, 2000 9:57 PM To: [EMAIL PROTECTED] Subject: SQL Error using 'Name' as fi

Re: SQL Error using 'Name' as field

sage - From: "Duane Boudreau" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, April 29, 2000 7:54 PM Subject: RE: SQL Error using 'Name' as field I'm not too familiar with the group by function but in order to use it you must be using an (Sum, Avg,