AnsweredAssumed Answered

Help with ExecuteSQL Query

Question asked by BrianBrouillette on Feb 12, 2014
Latest reply on Feb 12, 2014 by davidanders

Title

Help with ExecuteSQL Query

Post

      Hi -- I am trying to find unique members on a list and come up with a count.  In this case -- the field is "Customer" and I want to get the name of unique customers on list (one customer may be on the list many times)

     The Query I am trying:

     ExecuteSQL ("SELECT COUNT ( DISTINCT Customers)FROM RE Plan 2.0 Converted" ; "" ; "")

     Notes:

            The field name is Customers

             The file is RE Plan 2.0

           The results of query are "?"  and it should be 15

     Thanks in advance for your help

Outcomes