A Anima New member Local time Today, 10:37 Joined May 11, 2006 Messages 8 May 17, 2006 #1 i'm on a stump atm how would u count the total # of client in town to show on the query
N namliam The Mailman - AWF VIP Local time Today, 19:37 Joined Aug 11, 2003 Messages 11,693 May 17, 2006 #2 Select townname, count(townname) from your table group by townname Or pick up any old access book...