hi and thanx for the read Andy,

i apologize for the confusing question ... my dilemma is i need to know how many account #'s(one table) i have at each zip code(the other table), i can get total of each, total of both, averages, etc. however total # of accounts per zipcode eludes me... any help at all would be greatly appreciated