Thanks for the suggestion Andy, I have tried, but unfortunately Access does not like the 'REPLACE' component of the query. It would also seem as though the Access Update statement does not allow anything but a string, like UPDATE table SET Field = "String Only" WHERE Field = "1234" I might just have to delete them manually

Any other ideas would be hugely appreciated

MAD_MICK