Many thanks for your time and effort PNGBill, it is much appreciated.
I have gone away and started building a query based on your advise and all is going well so far.
I have a table that lists the orders and the company that placed the order. I also have a table with the address details of...