Thank you both for your help
My query in SQL View looks like this (I hope this is what you meant):
SELECT Main.PermitNumber, Main.PERM, Main.PermitType, Main.Status, Main.DateOfEnquiry, Main.DateFormsSent, Main.CompanyName, Main.CompanyBuildingNameOrNumber, Main.CompanyStreet...