Maybe Im being really dumb here but I just cant seem to do this (hopefully) simple task.
I'll try to explain:
I have an ASP survey and the responses are stored in an Access DB. Im trying to write an ASP page that will give statistics about responses to each question. However I only want the responses from certain people to be counted. I have written the SQL statement that filters out the people I dont want:
That works no problems, but now im stuck. The Responces table is made up of fields "Question1, Question2 ....." and so on. I just want the average for Question1 field!
Sorry to go on, probably not that clear, if anyone thinks they know what Im on about help would be appreciated!
I'll try to explain:
I have an ASP survey and the responses are stored in an Access DB. Im trying to write an ASP page that will give statistics about responses to each question. However I only want the responses from certain people to be counted. I have written the SQL statement that filters out the people I dont want:
Code:
SELECT Users.*, Responces.* FROM Users, Responces WHERE Responces.ID=Users.ID AND Users.TeamLeader = False AND Team =" &Session("Team")Sorry to go on, probably not that clear, if anyone thinks they know what Im on about help would be appreciated!
