I'm trying to group together employee data. An individuals badge number will show up in the table numerous times (ex: badge # 1234 will show up 5 times in five differnet rows in the table). I only want the badge number to show up once. The 2nd column is named Total, which could be 1-3. I want my query to group each badge number and count, not sum, all the 1's and 2's excluding the 3's. What would the query criteria look like (DCount)? How would I write it? I'm trying to goup the badge number and count the Total column but it counts the 3's. The formulas I'm using to exclude the 3's are not working? HELP!!!!