如何在访问中显示组

本文介绍了如何在访问中显示组的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 嗨朋友们， 这里我想显示成员住所不同的家庭成员，地址也一样。我正在使用访问数据库。这是我的查询 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.CardNoFROM 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.CardNoFROM voter where voter.YadiNo in (select voter.YadiNo from Voter group by Voter.houseno And Voter.address) 我认为它会起作用请试试，请回复其工作与否I Think It Will Work Please Try It,,Please Give Reply Its Working Or Not 这篇关于如何在访问中显示组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！