this is the SQL for the query...
SELECT DISTINCT [DISTRIBUTORS_MAILTO_BILLTO].[BILL_TO], [Customers].[STREET], [Customers].[CITY STATE ZIP], [Customers].[PHONE], [Customers].[FAX], [Customers].[CONTACT], [DISTRIBUTORS_MAILTO_BILLTO].[REP], [DISTRIBUTORS_MAILTO_BILLTO].[INVOICE #], [DISTRIBUTORS_MAILTO_BILLTO].[PO #], [DISTRIBUTORS_MAILTO_BILLTO].[TERMS], Format([Current_Date]+NZ([tblTerms].[DaysToAdd]),"mm/dd/yyyy") AS [Due Date], [DISTRIBUTORS_MAILTO_BILLTO].[SHIP DATE], [DISTRIBUTORS_MAILTO_BILLTO].[SHIP VIA], [DISTRIBUTORS_MAILTO_BILLTO].[ACCOUNT #], [DISTRIBUTORS_MAILTO_BILLTO].[SPECIAL INSTRUCTIONS], [DISTRIBUTORS_MAILTO_BILLTO].[UPS TRACKING#], [DISTRIBUTORS_MAILTO_BILLTO].[UPS TRACKING#2], [DISTRIBUTORS_MAILTO_BILLTO].[SHIPPING], [DISTRIBUTORS_MAILTO_BILLTO].[QUANTITY1], [DISTRIBUTORS_MAILTO_BILLTO].[DESCRIPTION1], [DISTRIBUTORS_MAILTO_BILLTO].[DESCRIPTION1B], [DISTRIBUTORS_MAILTO_BILLTO].[UNIT PRICE1], [DISTRIBUTORS_MAILTO_BILLTO].[QUANTITY2], [DISTRIBUTORS_MAILTO_BILLTO].[DESCRIPTION2], [DISTRIBUTORS_MAILTO_BILLTO].[DESCRIPTION2B], [DISTRIBUTORS_MAILTO_BILLTO].[UNIT PRICE2], [DISTRIBUTORS_MAILTO_BILLTO].[QUANTITY3], [DISTRIBUTORS_MAILTO_BILLTO].[DESCRIPTION3], [DISTRIBUTORS_MAILTO_BILLTO].[DESCRIPTION3B], [DISTRIBUTORS_MAILTO_BILLTO].[UNIT PRICE3], [DISTRIBUTORS_MAILTO_BILLTO].[QUANTITY4], [DISTRIBUTORS_MAILTO_BILLTO].[DESCRIPTION4], [DISTRIBUTORS_MAILTO_BILLTO].[DESCRIPTION4B], [DISTRIBUTORS_MAILTO_BILLTO].[UNIT PRICE4], [DISTRIBUTORS_MAILTO_BILLTO].[QUANTITY5], [DISTRIBUTORS_MAILTO_BILLTO].[DESCRIPTION5], [DISTRIBUTORS_MAILTO_BILLTO].[DESCRIPTION5B], [DISTRIBUTORS_MAILTO_BILLTO].[UNIT PRICE5], [DISTRIBUTORS_MAILTO_BILLTO].[QUANTITY6], [DISTRIBUTORS_MAILTO_BILLTO].[DESCRIPTION6], [DISTRIBUTORS_MAILTO_BILLTO].[DESCRIPTION6B], [DISTRIBUTORS_MAILTO_BILLTO].[UNIT PRICE6], [DISTRIBUTORS_MAILTO_BILLTO].[QUANTITY7], [DISTRIBUTORS_MAILTO_BILLTO].[DESCRIPTION7], [DISTRIBUTORS_MAILTO_BILLTO].[DESCRIPTION7B], [DISTRIBUTORS_MAILTO_BILLTO].[UNIT PRICE7], [DISTRIBUTORS_MAILTO_BILLTO].[CM #], [DISTRIBUTORS_MAILTO_BILLTO].[PAID], [DISTRIBUTORS_MAILTO_BILLTO].[MAIL_TO], [CUSTOMERS_DISTRIBUTOR_MAILTO_BILLTO].[STREET], [CUSTOMERS_DISTRIBUTOR_MAILTO_BILLTO].[CITY STATE ZIP], [CUSTOMERS_DISTRIBUTOR_MAILTO_BILLTO].[PHONE], [CUSTOMERS_DISTRIBUTOR_MAILTO_BILLTO].[FAX], [CUSTOMERS_DISTRIBUTOR_MAILTO_BILLTO].[CONTACT]
FROM tblTerms, (DISTRIBUTORS_MAILTO_BILLTO INNER JOIN Customers ON [DISTRIBUTORS_MAILTO_BILLTO].[BILL_TO]=[Customers].[COMPANY]) INNER JOIN CUSTOMERS_DISTRIBUTOR_MAILTO_BILLTO ON [DISTRIBUTORS_MAILTO_BILLTO].[MAIL_TO]=[CUSTOMERS_DISTRIBUTOR_MAILTO_BILLTO].[COMPANY];
the information that is repeating:
BRYANT INTERGRATED TECHNOLOGIES
and
CROW SECURITY
with all of their information.
hope this helps