[AccessD] select distinct per year

Susan Harkins harkins at iglou.com
Mon Apr 21 08:03:49 CDT 2003


Keep in mind, the results of a GROUP BY are read-only. 

Susan H. 


> SELECT Year([nDate]) , Sum(num1) , Sum(num2)
> FROM tNumbers
> GROUP BY Year([nDate])




More information about the AccessD mailing list