The more I think about it, I'm not sure even my first result will give you accurate results. Do you want the average answer for each question? If so, then you'll probably need to drop the TEXT answers and query them seperately to get "Most Common" answers to those questions.
On 4/15/05, Mills, Andy R. (Regency) <[EMAIL PROTECTED]> wrote: > > > 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 > > > > > [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/
