you tried to execute a query that does not include the specified expression ... as part of the aggregate function
Posted on 2004-10-25
Good morning! I have what I hope is an easy question for many of you experts.
When executing this query, I get the error: “you tried to execute a query that does not include the specified expression ‘CompID’ as part of the aggregate function”
SELECT PC.TagNum, Sum(Software.SoftCost) AS SumOfSoftCost
FROM Software, PC
GROUP BY Software.TagNum;
I'm just learning, and muddling my way through, so I appreciate the help. Are there general rules of thumb that I should know when it comes to Aggregate functions?