Primary Sales Rep

Hi Hozay - first edit the tables queried section so it reads... TablesQueried = "FROM Customer WITH(NOLOCK) LEFT JOIN SalesRep on Customer.SalesRepID = SalesRep.ID"

Then add your rep with the following column Begin Column FieldName = "SalesRep.Name" DrillDownFieldName = "" DrillDownReportName = "" Title = "Sales Rep" VBDataType = vbString Formula = "" ColHidden = False ColNotDisplayable = False FilterDisabled = False ColWidth = 1560 GroupMethod = groupmethodNone ColFormat = "" End Column

H> how can i edit the customer list report to show Primary Sales Rep