Hi all,

I have the following SQL statement in my ASP page:

"SELECT Trainer.TrainerName, FeedBack.CourseID, Max(AttendanceList.ClassDate) AS EndDate, Avg(FeedBack.CourseCon1)
AS AvgOfCourseCon1;"

I'm using Access as my backend database and CourseCon1 is actually an Integer field.

I'm able to call out the values of the rest of the fields but when I type this:

<%= rs("AvgOfCourseCon1") %>

It gaves me this error:

Microsoft VBScript runtime error '800a000d'

Type mismatch

/classrate.asp, line 122

What actually went wrong?

Thanks for any help!!