hi all - what i'm trying to do is count the number of times a particular value (in this case a team name) shows up in a data table (#1) that i've imported. so, if "team a" shows up 10 times, and "team b" shows up 83 times, etc ... i need access to give me that info. i think it's the "count" function that does it, but i'm not sure how to design the query. ---- additionally, i have another data table (#2) with all the possible teams listed. i would like to have a query that would show me what teams are *excluded* from data table #1? so, if "team z" and "team r" aren't in data table #1, i would like to know that as well. on this one, i have no clue what function to use. ----- thanks!