Hello Guys:
Since we had fun over the last couple days with SQL Queries: I want to have
some fun as well :-)
I have the following Query that isn't working:
SELECT
Question1, Question2, Question3, Question4, Question5, Question6,
Question7, Question8,
AVG(Question1) AS QAvg1, AVG(Question2) AS QAvg2, AVG(Question3) AS
QAvg3, AVG(Question4) AS QAvg4, AVG(Question5) AS QAvg5
FROM
tSurvey
GROUP BY
Question1, Question2, Question3, Question4, Question5, Question6,
Question7, Question8
The problem is: Question 6, Question7, Question8 are TEXT fields, and not
able to be grouped. However: If I don't include them in the group by: I
get an error because they are not part of an aggragate function. What would
I need to do to get this Query to work?
Thanks
Andy Mills
Programmer
Regency Thermographers
717-765-3572
<mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
http://www.regencythermo.com <http://www.regencythermo.com/>
[Non-text portions of this message have been removed]
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [email protected]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
