I need help writing a report that basically compares a table to itself. In This table each row of data contains a field for customer number, account type and account group type. Since we are a financial institution a customer can have numerous account types in this table. Here is an example:(each line represents a new row of data)

Customer Number          Account Type    Account Group Type

123456                                  1                            A

123456                                  2                             B

123456                                  3                             A

 So as you can see each account number can be listed several times in the table per account type. What I am trying to accomplish is pulling a report that shows customer numbers that don’t have a specific account type (say a 10) in the table. I can’t figure out for the life of me how to do this. My first guess is a loop or somehow using an array. Any suggestions?