mikev1976 Posted December 9, 2011 Share Posted December 9, 2011 I am pulling the names of people from my database where people have been trying to contact them but don't get in touch with them. For each call made, a call date is displayed and their name is listed. I am trying to display only the names of people that are listed more than 3 times but am having trouble doing so. The last part of my query is: and (select Count(*) from Member.Users as u2 where u.NameLast=u2.NameLast )>3order by u.NameLast attached are the results shown. I don't understand why Richard or Judith are showing up in the results since they have less than 3 entries. Thanks for any help Link to comment Share on other sites More sharing options...
mikev1976 Posted December 9, 2011 Author Share Posted December 9, 2011 I figured it out. The way the tables are layed out and stuff is tied together is very confusing. I should have been counting from a different table. Tried to get rid of this post but didn't know how so wouldn't waste anyones time. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.