Recent content by The Nine Inch Ninja

Re: First Attempt Hi Darbid, does this work in access 2003, I've tried your example but no joy!

Brilliant, cheers. Tried it before spitting out all that code, but it was really slow. Turns out I just have a really slow computer (at work) and too much data. Broke it down into more managable chunks so the PC can keep up!

Morning All. I have a DB of Delayed Transfers of Care (I work for the NHS) I need to compare the new information to be entered into the table (DTOC Import Table) with information already in the main table (DTOC Data Table) before inserting it. This is to ensure that no duplicates are...