I am trying to produce an exception report (table). I have two tables of data (Orders & Customer) that both have a field called Account Number. The Orders table may have multiple lines containing the account number and there may be duplicated ones in the Customer table (this probably won't matter but thought I'd mention it).
Besically what I am trying to do is produce a list (table) of unique account numbers that exist in the Orders table but NOT in the Customer Table. I want to be able to do this in a table as well rather than scripting. The idea is the Account NUmbers that don't exist in the customer table are reported on and added to the customer table manually.
