Referring to a field and using an aggregate function in 1 sql

[Ciarak]

Hi,
when I try to query the database using the query "SELECT Refdes,Avg(Area),Stdev(Area)From RefdesResults",I get the following error "You tried to execute a query that does not include the specified expression as part of an aggregate function or grouping".Preumbly this means that if I use an aggregate function such as Avg then my recordset can't also return a field such as Refdes.Is there a way around this.

 

[StevenK]

Is the 'Refdes' field listed in your GROUP BY clause ?
The SQL syntax should operate if it is included.
Steve