AVG

Im try to find out which stuents had a greater then avg grade how do i write
this?

I tryed the below no luck.

SELECT studentname
FROM students
WHERE grade = AVG (grade);

Try these two queries ----
Grade_AVG ---
SELECT Avg(Students.grade) AS AvgOfgrade
FROM Students;

SELECT Students.StudentName, Students.grade
FROM Students, Grade_AVG
WHERE (((Students.grade)=[AvgOfgrade]));

--
KARL DEWEY
Build a little - Test a little


"Octet32" wrote:

Im try to find out which stuents had a greater then avg grade how do i write
this?

I tryed the below no luck.

SELECT studentname
FROM students
WHERE grade = AVG (grade);

I would think that the following would give you the result you say you want.

SELECT StudentName
FROM Students
WHERE Students.Grade =
(SELECT Avg(Grade)
FROM Students)



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Octet32" wrote in message
news
Im try to find out which stuents had a greater then avg grade how do i
write
this?

I tryed the below no luck.

SELECT studentname
FROM students
WHERE grade = AVG (grade);

Thanks

"John Spencer" wrote:

I would think that the following would give you the result you say you want.

SELECT StudentName
FROM Students
WHERE Students.Grade =
(SELECT Avg(Grade)
FROM Students)



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Octet32" wrote in message
news
Im try to find out which stuents had a greater then avg grade how do i
write
this?

I tryed the below no luck.

SELECT studentname
FROM students
WHERE grade = AVG (grade);