use current record to filter subquery

[Ghena]

SELECT feedback.id_user, feedback.risposta1, feedback.feed_value ,
(select count(id) from feedback where id_user =7 and feed_value =
feedback.feed_value and risposta1 = true ) AS Espr1
FROM feedback
GROUP BY feedback.id_user, feedback.risposta1, feedback.feed_value
HAVING (((feedback.id_user)=7) AND ((feedback.risposta1)=True));


I need to filter the subquery :

(select count(id) from feedback where id_user =7 and feed_value =
feedback.feed_value and risposta1 = true )

using each current record in feedback.feed_value
I'm using Access

Thanks in advance...

 

[John Spencer]

Perhaps what you want is the following

SELECT DISTINCT feedback.id_user
, feedback.risposta1
, feedback.feed_value
, (SELECT Count(id_User)
FROM feedback as F
where F.id_user =FeedBack.idUser
and F.feed_value =feedback.feed_value
and F.risposta1 = true ) AS Espr1
FROM feedback
WHERE feedback.risposta1=True

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