I found the email tom posted on the 4th about this same thing. I tried avariation on the suggestion in that email and it still complained: "Illegaluse of aggregates or non-group column in target list".