Hi Kenny

Thanks for the suggestion. I have now put the full database names in for each reference to a table within the query, but I still get the same error,...

Perfect, worked first time. Many thanks for your reply, Adaddio