Thanks so much for the great response. Our broadband has been down (good old BT) but we're back up now.

Query runs OK but I am still getting duplicates in...

Thanks very much for replies.

The Weekly table does not have a PK as it is a table linked to an Excel spreadsheet which is to be copied on a weekly...

Thanks very much - that works fine

Thanks for the help - I used the last reply and it worked fine. It will be something I will need to use frequently