That is what I am afraid of. I really wanted to get one result back, as it would be so much easier for the task I am doing. But thanks for the time and help Andy
_____ From: [email protected] [mailto:[EMAIL PROTECTED] Sent: Friday, April 15, 2005 3:24 PM To: [email protected] Subject: Re: [ASP] SQL Query 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> <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 <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 <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/ <http://groups.yahoo.com/group/active-server-pages/> * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> . [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/
