In the main form (as there are many) if I go into the property sheet of the form and then go into record source it states,
SELECT [tblCustomerInfo].[Surname], [tblSalesSheet].[Job No], [tblSalesSheet].[BkgDate], [tblSalesSheet].[BkgTime], [tblSalesSheet].[AM/PM], [tblSalesSheet].[Staff Init]...