Group: microsoft.public.access · Group Profile · Search for B88e in microsoft.public.access
Author: tom
Date: Sep 18, 2008 10:17
Sure. The only rule is that every field mentioned in the query must either have an aggregate function applied to it, or else must be in the GROUP BY clause. To sum C, grouping by A, the SQL would be: SELECT A, Sum(C) FROM MyTable GROUP BY A -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "tom" <Spamblocker@ameritech.net> wrote in message news
|