如何在访问中显示组 [英] How to display the group by in access

问题描述

嗨朋友们，



这里我想显示成员住所不同的家庭成员，地址也一样。我正在使用访问数据库。这是我的查询

Hi friends,

Here i want to display the family member where the members house no is same and also address is same. I am using the access database.here is my query

SELECT voter.SrNo, voter.YadiNo, voter.fullname, voter.houseno, voter.address, voter.Gender, voter.Age, voter.CardNo
FROM voter 
WHERE (((voter.YadiNo) Between 1 And 1) 
AND ((voter.houseno) 
In (SELECT [houseno] FROM [Voter] As Tmp GROUP BY [houseno]  HAVING Count  (houseno)>=5 and  Count  (houseno)<=5 ))) 
ORDER BY voter.houseno;

但是在这个查询中它显示了相同的房子，但是显示了不同的地址。



我想显示同一个房子没有和相同的地址。



提前谢谢。

but in this query it show same house but display the different address.

I want to show same house no and same address .

Thanks in advance.

推荐答案

SELECT voter.SrNo, voter.YadiNo, voter.fullname, voter.houseno, voter.address, voter.Gender, voter.Age, voter.CardNo
FROM voter where  voter.YadiNo in (select voter.YadiNo from Voter group by Voter.houseno And Voter.address)

< br $>




我认为它会起作用请试试，请回复其工作与否

I Think It Will Work Please Try It,,Please Give Reply Its Working Or Not

这篇关于如何在访问中显示组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！