T
Tony
Would really appreciate if someone could help. I am using the payment records of a company to run variable duplicate payment reports. The first is easy in Duplicate Wizard where Supplier #, Invoice #, Invoice DT and Invoice AMT are all the same. I have 12 other variables of this though, in the next query I still need the records where the Invoice #, Invoice DT and Invoice AMT are the same, but I need the Supplier # to be different. The other queries follow the same suit with the next having the Supplier #, Invoice DT and Invoice AMT the same and the Invoice # must be different. I can get the query to include all the records, I just need it to exclude the ones where I need the records to be different and it continues including same records. Thank you