Here is what I have so far;
SELECT ServiceJobCards.Job_Number, ServiceJobCards.Work_Done_Date, ServiceJobCards.DeliveryType, ServiceJobCards.ServiceType, ServiceJobCards.CustomerID, ServiceJobCards.ModelNumber, Customers.[First Name], Customers.Surname, Sum([ServicePartsOrders]![Unit...