THis is the amended Single.
You can work out how to replace the 1 key with whatever value you need?
Code:
SELECT tblCompanies.CompanyName, tblCompanies.ContactTitle, tblCompanies.ContactFirstName, tblCompanies.ContactLastName, tblEquipment.EquipModel, tblEquipment.SerialNumber, tblEquipment.ContractRate, tblEquipment.EquipOwner, tblTaxs.TaxCounty, tblTaxs.TaxRate, tblCompanies.CompanyAddress, tblCompanies.CompanyCity, tblCompanies.CompanyStateProvince, tblCompanies.CompanyZipPostalCode, tblCompanies.CompanyDiscount, tblCompanies.TaxExempt, tblCompanies.ContractStartDate, tblCompanies.ContractEndDate, tblTaxs.SurTaxRate, IIf([tblEquipment].[ContractRate]>5000,5000,[tblEquipment].[ContractRate]) AS cappedAmt, tblEquipment.EquipNote, tblCompanies.CompanyID_PK, tblCompanies.ParentCompanyID_FK, tblCompanies.CompanyName
FROM tblTaxs INNER JOIN (tblCompanies INNER JOIN tblEquipment ON tblCompanies.CompanyID_PK = tblEquipment.EquipOwner) ON tblTaxs.TaxZipCode = tblCompanies.CompanyZipPostalCode
WHERE (((tblCompanies.CompanyID_PK)=1)) OR (((tblCompanies.ParentCompanyID_FK)=1))
ORDER BY tblCompanies.CompanyName, tblCompanies.ParentCompanyID_FK;
I included the PK/FK just to check the output.
HTH