SELECT [tblEstimates].[EstimateID], [tblEstimates].[CompanyID], [tblEstimates].[CustomerID],
    [tblEstimates].[ProjName], [tblEstimates].[PO#], IIf(IsNull([ContactPh]),[tblCustomers].[Phone],[ContactPh])
    AS Phone, IIf(IsNull([ContactFx]),[tblCustomers].[Fax],[ContactFx]) AS Fax, [tblEstimates].[ExpectQty],
    [tblEstimates].[EstDate], [tblEstimates].[ContactName] AS Attn, [tblEmployee]![FirstName] & " " &
    [tblEmployee]![LastName] AS SRName, [tblEstimates].[PermitNum], [tblEstimates].[Terms],
    [tblEstimates].[DataIn], [tblEstimates].[DueIn], [tblEstimates].[Post$Due], [tblEstimates].[DropDate],
    [tblEmployee].[email], [tblEstimates].[OrderComments], [tblCustomers].[CustCode],
    [tblCustomers].[Company], [tblCustomers].[Taxable], [tblCustomers].[address1] & " " &
    [tblCustomers].[address2] AS Address1, [tblCustomers].[City], [tblCustomers].[State], [tblCustomers].[Zip],
    [tblAdmin].[CompanyName], [tblAdmin].[CompanyAddress], [CompanyCity] & "  " & [CompanyState] & ". " &
    [CompanyZip] AS CSZ, [tblAdmin].[CompanyPhone], [tblAdmin].[CompanyFax], [tblAdmin].[CompanyLogo],
    [tblAdmin].[TaxRate], [tblAdmin].[CompanyCity], [tblAdmin].[CompanyState], [tblAdmin].[CompanyZip]
    FROM (((tblCustomers RIGHT JOIN tblEstimates ON
    [tblCustomers].[CustomerID]=[tblEstimates].[CustomerID]) LEFT JOIN tblAdmin ON
    [tblEstimates].[CompanyID]=[tblAdmin].[CompanyID]) LEFT JOIN tblEmployee ON
    [tblEstimates].[SalesRep]=[tblEmployee].[EmployeeID]) LEFT JOIN qryContactPhFxEst ON
    [tblEstimates].[ContactName]=[qryContactPhFxEst].[ContactName];