Code:
SELECT IIf(IsNull([CustomerFirstName2]), [Tbl_WorkOrders] ! [JobCustomer], [Tbl_WorkOrders] ! [JobCustomer] & " & " & [CustomerFirstName2] & " " & [CustomerLastName2]) AS JobCustomer
,tbl_Workorders.JobID
,[Tbl_Customers] ! [Customer] AS Customer
,IIf(IsNull([JobCustomer]), [BillingContactCompanyName], [BillingContactFirstName] & " " & [BillingContactLastName]) AS BillingContactOld
,Len([BillingContact]) AS BCLength
,Trim(IIf(IsNull([BillingContactCompanyName]), [BillingContactFirstName] & " " & [BillingContactLastName], [BillingContactCompanyName])) AS BillingContact
,tbl_Workorders.JobContact
,[CustomerFirstName2] & " " & [CustomerLastName2] AS 2 ndContact
,tbl_Customers.CustomerFirstName2
,tbl_Customers.CustomerLastName2
,IIf(IsNull([customer]), "", [customer] & " " & [customerlastname]) AS Cust
,tbl_Customers.EmailOne
,tbl_Customers.EmailTwo
,tbl_Customers.BillingHouseNumber
,tbl_Customers.BillingStreet
,tbl_Customers.BillingAddress
,tbl_Customers.BillingCity
,tbl_Customers.BillingState
,tbl_Customers.BillingZip
,tbl_Customers.BillingPhone1Type
,tbl_Customers.BillingPhone1
,tbl_Customers.BillingExt1
,tbl_Customers.BillingPhone2Type
,tbl_Customers.BillingPhone2
,tbl_Customers.BillingExt2
,tbl_Customers.BillingPhone3Type
,tbl_Customers.BillingPhone3
,tbl_Customers.BillingExt3
,tbl_Customers.BillingPhone4Type
,tbl_Customers.BillingExt4
,tbl_Customers.BillingFax
,"Thank you, " & [estimator] AS Thanks
,"6820 South Ave. Saint Paul, MN 55344" AS MHStreet
,"612-328-4789 -- 952-345-0124 -- 651-366-4785" AS MHPhone
,tbl_Customers.CustomerLastName
,tbl_Workorders.JobHouseNumber
,tbl_Workorders.JobStreet
,tbl_Workorders.JobSt
,tbl_Workorders.JobAddress
,tbl_Workorders.JobCity
,tbl_Workorders.JobZip
,tbl_Workorders.JobPhone1Type
,tbl_Workorders.JobPhone2Type
,tbl_Workorders.JobPhone3Type
,tbl_Workorders.JobPhone4Type
,tbl_Workorders.JobContactPhone4
,tbl_Workorders.JobContactPhone1
,tbl_Workorders.JobContactPhone2
,tbl_Workorders.JobContactPhone3
,tbl_Workorders.JobStart
,tbl_Workorders.CreateDate
,tbl_Workorders.Estimator
,tbl_Workorders.JobSiteEmployee
,tbl_Workorders.JobReference
,tbl_Workorders.Notes
,Q_113_d_SumPreInvoiceJobMisc.JobMiscCost
,Q_113_a_SumPreInvoiceJobTime.JobTimeRate
,Q_113_b_SumPreInvoiceJobFees.JobFeePrice
,Q_113_c_SumPreInvoiceJobMaterial.JobMaterialTotal
,Q_113_e_SumPreInvoiceJobContract.JobContractAmount
,tbl_Workorders.JobPaymentDown
,tbl_Workorders.JobPaymentDownNote
,tbl_Workorders.JobPaymentDownNoteExt
,tbl_Workorders.JobPayment1
,tbl_Workorders.JobPayment1Note
,tbl_Workorders.JobPayment1NoteExt
,tbl_Workorders.JobPayment2
,tbl_Workorders.JobPayment2Note
,tbl_Workorders.JobPayment2NoteExt
,tbl_Workorders.JobPaymentFinal
,tbl_Workorders.JobPaymentFinalNote
,tbl_Workorders.JobPaymentFinalNoteExt
FROM tbl_Customers
INNER JOIN (
(
(
(
(
tbl_Workorders LEFT JOIN Q_113_a_SumPreInvoiceJobTime ON tbl_Workorders.JobID = Q_113_a_SumPreInvoiceJobTime.JobID
) LEFT JOIN Q_113_b_SumPreInvoiceJobFees ON tbl_Workorders.JobID = Q_113_b_SumPreInvoiceJobFees.JobID
) LEFT JOIN Q_113_c_SumPreInvoiceJobMaterial ON tbl_Workorders.JobID = Q_113_c_SumPreInvoiceJobMaterial.JobID
) LEFT JOIN Q_113_e_SumPreInvoiceJobContract ON tbl_Workorders.JobID = Q_113_e_SumPreInvoiceJobContract.JobID
) LEFT JOIN Q_113_d_SumPreInvoiceJobMisc ON tbl_Workorders.JobID = Q_113_d_SumPreInvoiceJobMisc.JobID
) ON tbl_Customers.CustomerID = tbl_Workorders.CustomerID
WHERE (((tbl_Workorders.JobID) = [Forms] ! [Frm_Customer_WorkOrders] ! [JobID]));