Remove the code from the report. I have already said that having it there is not logical.
You have a type mismatch between the Customer TypeID primary and foreign key fields. This is causing the Invoice query to fail. You are saving the PK TypeID (autonumber value) into a TypeID text field in Customers. Since the TypeDesc is just a single letter, make it the PK and eliminate the autonumber PK, table join will not be needed. Fix the TypeID data in Customers table.