Recent content by Garren

Thanks for your help. It might make a difference if you know that when we receive the CD from the external consultant the Reports are tables rather than queries. Perhaps they do this becuase they don't want us copying how to run the dupes reports! If possible, I would like to be able to keep...

Thanks chaps for replying. I'm sorry if I've caused any confusion but let me make a few things clear: my company does not make or receive any of the duplicated payments. Our clients are large multinational companies who process and pay several hundred thousand invoices per annum. When they are...

Thanks chaps for replying. I'm sorry if I've caused any confusion but let me make a few things clear: my company does not make or receive any of the duplicated payments. Our clients are large multinational companies who process and pay several hundred thousand invoices per annum. When they are...

Thanks chaps for replying. I'm sorry if I've caused any confusion but let me make a few things clear: my company does not make or receive any of the duplicated payments. Our clients are large multinational companies who process and pay several hundred thousand invoices per annum. When they are...

Thanks for your reply. The data comes from our clients' accounts payable systems and we're specifically looking for invoices that have been entered into the system twice and therefore paid twice. Report 1 will do a duplicate test on supplier number, invoice number, invoice date and amount...

Hello everyone. I use Duplicates Wizard to run about 14 queries which will show all possible combinations of duplicated records in an access table. Can anyone tell me how to add an extra column in reports 2 onwards displaying either a "yes" or a blank cell, being the answer to the question...